Pick x number of rows from mysql table and display with php
i am currently designing the welcome page for my website and i would like to display random images from my database on the home screen.
i have many images stored in my database and each time someone visits the site i would like 4 random pictures to be selected from my db and displayed. i have heard about the rand() php function but heard that for large databases this is a bad one to use.
i really am stumped on this, thanks in advance to anyone who can help :):confused: