SELECT banID, banDate, banSupplier, banProfile, banLink, banLoc FROM sitebanners WHERE banLoc='CenterPage' ORDER BY RAND() LIMIT 1
would be the only way to do this using the recordset, this can be slow on a large dataset though.
if you are using MySQL 5, you may be able to speed this up by using a view. a view is basically a recordset that is executed on the MySQL Server.
we cannot offer support for creating the view, this is entirely dependent on your server MySQL Configuration.
if the server does support creating views, you can use phpMyAdmin or another GUI tool to access the MySQL Database, and run the following query:
CREATE VIEW randomBanLoc AS SELECT banID, banDate, banSupplier, banProfile, banLink, banLoc FROM sitebanners WHERE banLoc='CenterPage' ORDER BY RAND()
this will create a view named randomBanLoc in your database.
in your page, use the following SQL for the recordset:
SLECT * FROM randomBanLoc LIMIT 1
see the following for more on creating views:
create-view.html