> The solution I have been using is to do three queries similar to the below
> SELECT * FROM table WHERE field='ID00025'
> SELECT * FROM table WHERE field<'ID00025' ORDER BY field DESC LIMIT 0,1
> SELECT * FROM table WHERE field>'ID00025' ORDER BY field ASC LIMIT 0,1
> If you whish more row returned change the number in the LIMIT
Why bother with 3 queries? It's a waste of resources, especially if
you are working with the same record set...
Example (pseudo)code:
<?
$query = "SELECT * FROM table";
$result = mysql( $dbname, $query );
for( $i = 0; $i < mysql_num_rows( $result ); $i++ ) {
echo "Previous field: " . mysql_result( $result, ( $i - 1 ), "field" );
echo "Current field: " . mysql_result( $result, $i, "field" );
echo "Next field: " . mysql_result( $result, ( $i + 1 ), "field" );
}
?>
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
