|
Posted by thehuby on 01/05/07 21:39
Sir, you are a legend.
Rick
Rik wrote:
> thehuby wrote:
> > I have a table of articles and I want to grab 3 at random - is there a
> > way I can do this using SQL or will I have to get all results out then
> > pick them at random using PHP (something like rand() based on the size
> > of the result set?)
>
> SELECT .... ORDER BY RAND() LIMIT 3
> --
> Rik Wasmus
Navigation:
[Reply to this message]
|