[Resolved] Random

[scialom]

Hi,

How can I select one record from my db randomly?

For example:
Sql = "select * from tbl_pro"

I want each time to get a different one results.

Thanks,
Assaf

[devinemke]

SELECT * FROM tbl_pro ORDER BY RAND() LIMIT 1

[scialom]

Thanks!