Hi! I just posted the following silly (in retrospect) question
>I'd like very much to be able to walk backwards
>through a list of my
>records. How might I indicate
>that mysql ought to position itself at the
>highest record number and then all selects
>will go backwards (say with LIMIT 1) ?
I immediately realised my stupidity in this one and sorry for the
unnecessary noise on the list. If anyone as uninformed as me is curious,
here is how to do it:
$next=MYSQL_QUERY("select ref from questions where ref < $ref[0] ORDER BY
ref DESC LIMIT 1");
Cheers!
-Warren
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
