Random Select
Posted: Fri May 02, 2003 7:57 am
Hi
is it possible to select say 5 random records from a database (MYSQL) which satisfy a certain criteria, eg SELECT RANDOM(5) from useers where user='alive'?
or would it need some sort of PHP intervention?
Thanks
is it possible to select say 5 random records from a database (MYSQL) which satisfy a certain criteria, eg SELECT RANDOM(5) from useers where user='alive'?
or would it need some sort of PHP intervention?
Thanks