2007. 05. 17, csütörtök keltezéssel 00.45-kor Larry Garfield ezt írta:
> 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.
ORDER BY RAND can be very unefficient on large tables.
some useful info here:
http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/
greets
Zoltán Németh
>
> --
> 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
