The forums ran from 2008-2020 and are now closed and viewable here as an archive.
Home › Forums › Back End › PHP MySQL Rotating Ads › Re: PHP MySQL Rotating Ads
@TT_Mark has it right.
SELECT * FROM table ORDER BY RAND() LIMIT 1;