Hi Larry,Paul,Zoltán Thanks for your messages, adding ORDER BY RAND () worked just fine :) Eduardo "Larry Garfield" <larry@xxxxxxxxxxxxxxxx> escribió en el mensaje news:200705170045.40970.larry@xxxxxxxxxxxxxxxxxxx > 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
