[PHP] Re: OT [PHP] querying for one specific row number From: 1LT John W. Holmes (holmes072000 <email protected>)
Date: 07/17/02

Off topic...

> >So let's say my table had 5 rows (entries) in it, and I want to pull
> >just row #2, how would I do this??

> SELECT * FROM table LIMIT 1,1;

Technically, without an ORDER BY in your query, the database can return a
different row each time with this query. Without an ORDER BY, how do you
define row #2? The database just stores the data in any way it wants to and
doesn't order it unless you tell it to.

---John Holmes... 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php