Re: next/previous on a date select query

[ade harris]

ok but what value am i passing the the "next.php" page ?

ie: <a href="next.php?ID=<?php echo $result_ar['ID']; ?>">Next</a>

where the next.php page is

$result = mysql_query("SELECT a.ID, a.djs, a.photo, a.comments,
UNIX_TIMESTAMP(a.date) AS unixdate
FROM test a, test b
WHERE a.date > b.date
AND b.ID = $left_off
ORDER BY a.date ASC
LIMIT 3", $connection) or die("error querying database");

and would the echo be:

<?php echo $result_ar['a.djs']; ?>

confused.com ;)