Jack van Zanen wrote:
As a caution,
I would never, ever use a query that relies on the data to be returned from the table in a certain order. That is just wrong and goes against the principals of a rdbms.

I don't know that it goes against the principle, it's more that a database will never guarantee the order of results unless you tell it the order to use.

ie unless you specify an order by, the db will return the rows as soon as it finds them (which may appear random but it's not really, it's to do with where the row will be in the data/index file).

To the OP: why does it matter where the row appears in the list?

--
Postgresql & php tutorials
http://www.designmagick.com/


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

Reply via email to