Search the Community
Showing results for tags 'php mysql navigation links'.
Found 1 result
-
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
