[Resolved] Random Selection from a database

[thewalluk]

I am currently working a photo album script. I was wondering weather it was possible to show a random picture by selecting from a database.

Example

<LIST OF ALBUMS> <RANDOM PICTURE FROM DB>

I have been using the srand function but I don't know if I can apply that to what I want.

[drawmack]

if you're using mysql you can ORDER BY RAND() right in the query

[thewalluk]

It works perfectly. Thank you very much