Re: OT [PHP] querying for one specific row number
| From: | 1LT John W. Holmes | Date: | Wed, 17 Jul 2002 15:42:30 +0000 |
| Subject: | Re: OT [PHP] querying for one specific row number | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-108099@lists.php.net to get a copy of this message | ||
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...