php mysql next link

[dwperry1]

The following code works great:

 

PHP:

<?php

//connection stuff:

 

$current_id = $_GET['record_id'];
$record_id = $current_id;

 

$nextquery= "SELECT * FROM daily_sales WHERE record_id > $current_id ORDER BY record_id ASC LIMIT 1";
$nextresult = mysql_query($nextquery) or die(mysql_error());
while($nextrow = mysql_fetch_array($nextresult))
{
$nextid  = $nextrow['record_id'];
}

 

?>

 

HTML:

 

<a href="http://www.mywebsite.com/view?record_id=<?php echo $nextid; ?>">Next</a>

 

 

PROBLEM:

 

I need to swap 'record_date' for 'record_id' in the above code.  When I do, I get the following 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 'ORDER BY record_date ASC LIMIT 1' at line 1

 

 

Does anyone have an idea why this is happening?

 

Any help would be appreciated.

view.php

[ginerjm]

Do you mean you have this in your query:

 

WHERE record_date > $current_id

 

??

 

You can't compare a date field to a numeric value. At the least I think you need quotes, if that is really a valid test for your application