Re: OT [PHP] querying for one specific row number

From: 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...

« previous php.general (#108099) next »