mysq query error ...

[pepelepew1962]

Hello:

 

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.

 

 

php version=5.3.1

mysql version=5.1.41

 

 

Error:

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

 

 

Pagination:

http://www.catchmyfame.com/2007/07/28/finally-the-simple-pagination-class/

 

 

 

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[0];

    $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());

 

 

Thank You.

[Pandemikk]

In the future please enclose code with the

 tag.

The reason for your error is because you don't have an ORDER BY clause in front of ASC.
http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html

[pepelepew1962]

sorry for not using tags.

FYI - It works, awesome, thanks !!!