After performing a search only the found records are showing on the results page

I'm using DataAssist to create a back-end admin system. My results page works correctly initially. If I do a search for some records the results page displays the found records correctly.

However, once I've carried out a search my results page will not list anything other than the records it found, what I mean is if I go into other areas of the system and then just click on the link to display the results page again (having not performed any additional searches) I only ever get the records it found through my initial search displaying, it's no longer possible for me to see all records. It's like the page has cached the search results and is only going to display them. The only way I've found to correct this is to log out of the admin system and then log back in again, which is obviously not how I want it to work.

I need the system to display all records again, not just the one(s) it found previously once the initial search has been completed.

I've attached a copy of my search page and my results page in the zip file. (hope I've explained myself correctly - its a little difficult to describe)

In you articles page replace the search code with the following:

<?php

//WA Database Search (Copyright 2005, WebAssist.com)

//Recordset: WADAtblnews;

//Searchpage: tblnews_Search.php;

//Form: WADASearchForm;

$WADbSearch1_DefaultWhere = "";

if (!session_id()) session_start();

if ((isset($_GET["Search"]) && $_GET["Search"] != "")) {

  $WADbSearch1 = new FilterDef;

  $WADbSearch1->initializeQueryBuilder("MYSQL","1");

  //keyword array declarations



  //comparison list additions

  $WADbSearch1->addComparisonFromEdit("ArticleID","S_ArticleID","AND","=",1);

  $WADbSearch1->addComparisonFromEdit("Headline","S_Headline","AND","Includes",0);

  $WADbSearch1->addComparisonFromEdit("Article","S_Article","AND","Includes",0);

  $WADbSearch1->addComparisonFromEdit("DatePosted","S_DatePosted","AND","=",2);



  //save the query in a session variable

  if ((isset($_GET["Search"]) && $_GET["Search"] != "")) { // this line has changed

    $_SESSION["WADbSearch1_tblnews_Results"]=$WADbSearch1->whereClause;

  }

}

else     {

  $WADbSearch1 = new FilterDef;

  $WADbSearch1->initializeQueryBuilder("MYSQL","1");

  //get the filter definition from a session variable

  if ((isset($_GET["Search"]) && $_GET["Search"] != "")) { // this line has changed

    if (isset($_SESSION["WADbSearch1_tblnews_Results"]) && $_SESSION["WADbSearch1_tblnews_Results"] != "")     {

      $WADbSearch1->whereClause = $_SESSION["WADbSearch1_tblnews_Results"];

    }

    else     {

      $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;

    }

  }

  else     {

    $WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;

  }

}

$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);

$WADbSearch1whereClause = '';

?>

The session variable that holds the search results will now only be triggered when the search button is pressed.

Thank you Dave, I'll give that a go. Was it something that I had done causing this or is it a bug in DataAssist? If so I'll make sure to keep the code you provided to hand for future projects.

It's what I would call a Data Assist Feature :)

It used to drive me crazy till I found out how to stop it happening

another way to go about this is to update the link to your results page to be as follow:

results.php?Search_x=1

Thanks Dave, that worked a treat. Much appreciated.

No worries, glad it helped you