[thelist] MySQL queries and AUTO_INCREMENT

Joshua Olson joshua at waetech.com
Fri Apr 7 12:24:51 CDT 2006


> -----Original Message-----
> From: Max Schwanekamp
> Sent: Friday, April 07, 2006 12:38 PM
> 
> 3. If no data returned, query once more:
>     SELECT [fields] FROM mytable WHERE id < $x LIMIT 1

This is an interesting concept and will presumably work.  You may need to
add in an ORDER BY clause here, though.

<><><><><><><><><><>
Joshua L. Olson
WAE Technologies, Inc.
http://www.waetech.com/
Phone: 706.210.0168
Fax: 413.812.4864

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/ 



More information about the thelist mailing list