quick php/mysql

[alex79]

i have a table with 1000 urls

what is the easyest way to display 20 random url's?

[Spudstr]

use this query select * from TABLE order by rand() limit 20

contact me if you want me to code somthing

[alex79]

Originally posted by Spudstr
use this query select * from TABLE order by rand() limit 20

with his will be 20 consecutive urls? becouse i don't want to be consecutive

[Spudstr]

no, it should pull 20 random rows open up a mysql client and run it a couple times.

[fuzebox]

Originally posted by alex79


with his will be 20 consecutive urls? becouse i don't want to be consecutive

That's what the "order by rand()" part is for ;)