On Wednesday 16 May 2007, Eduardo Vizcarra wrote:
> Hi
>
> I would like to know if a SELECT SQL query list of records can be unsorted.
> SELECT statement retrieves a list of records from a certain table starting
> from record # 1 till record #N and when publishing the records, this is how
> it is presented, in a sequential way, is there any way to not present them
> in a sequential way ? e.g. if a user accesses a web page then he will see
> record #3 and then #7 and so on, another user accesses the same web page
> and he might see record #8 and then record#2..... etc
>
> any experience on how to do this ?
This is really an SQL question, but it's quite easy. Assuming MySQL:
$result = mysql_query("SELECT * FROM foo WHERE bar='baz' ORDER BY RAND()");
// Do stuff here.
--
Larry Garfield AIM: LOLG42
larry@xxxxxxxxxxxxxxxx ICQ: 6817012
"If nature has made any one thing less susceptible than all others of
exclusive property, it is the action of the thinking power called an idea,
which an individual may exclusively possess as long as he keeps it to
himself; but the moment it is divulged, it forces itself into the possession
of every one, and the receiver cannot dispossess himself of it." -- Thomas
Jefferson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
