Random posts from mysql

[alcstudio]

Hey there. i wonder how i do to get 4 radom posts displayed on my webpage from mysql.

For example. If i have total 10 images and every time i reload the page it changes between this 10 and show 4.

[ronverdonk]

Select images at random from your gallery table and show them, e.g.
[php]SELECT * FROM gallery ORDER BY RAND() LIMIT 4[/php]
Ronald

[alcstudio]

Thanks. I have used Access for to long.

[ronverdonk]

You are welcome. See you next time.

Ronald