I am having a problem fixing/understanding a recent error message. Basically, I have a search form that after validation and filtering stores the variable into a session. Another page/file opens and loads that search field. Everything has always worked but I recently added pagination and suddenly this program no longer works. Any assistance would greatly be appreciated.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ASC LIMIT 0,10’ at line 1
Here is the shortened version of the code:
include('../pagination/paginator.php'); $searcher = $_SESSION['sessearchcode']; $query = "SELECT COUNT(*) FROM tblLoad, tblCode WHERE (tblLoad_LoadID = tblCode_CodeID) AND tblCode_Manufact LIKE '%$searcher%'"; $result = mysql_query($query) or die(mysql_error()); $num_rows = mysql_fetch_row($result); $pages = new Paginator; $pages->items_total = $num_rows; $pages->mid_range = 9; // Number of pages to display. Must be odd and > 3 $pages->paginate(); $query = "SELECT tblLoad_LoadID, tblLoad_Company, tblLoad_State, tblCode_CodeID from tblLoad, tblCode WHERE (tblLoad_LoadID = tblCode_CodeID) AND tblCode_Manufact LIKE '%$searcher%' ASC $pages->limit"; $result = mysql_query($query) or die(mysql_error());