On Fri, May 11, 2007 07:15, Richard Kurth wrote: > How would I find the next id and the prev id in sql statement like the one > below. The id number is not going to be in order so I can't do a < or > > limit 1 on the search > > SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND > members_id= '8' ORDER BY lastname
The PHP variant could look like (prev id): SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND members_id= '8' AND lastname < $_POST['lastname'] ORDER BY lastname LIMIT 1; -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]