Hi, I'm trying to make a query to my database based upon an index. Eg. we have last name,first name, eyecolour,age we search for all the records with the last name starting with 'smi' and I'm browsing forward through the records using mysql_use_result I get halfway through the last name 'smith' and now I want to browse backwards through the records organized by that key however if I say >='smith' it wont necessarily pull up the previous record.
Help would be very much appreciated, -Andrew --------------------------------------------------------------------- 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
