I have set up a random product display on my homepage using my own coding of PHP/MySQL. Right now, I have my code pulling a random product from the MAIN PRODUCT TABLE:
However, I would like to display only products from ONE SPECIFIC CATEGORY, rather than from the whole list of products. Is there a table to do so, and if so which one? Any other ideas?
Thank you.
PHP Code:
mysql_query( "SELECT name, price, thumbnail FROM s01_Products ORDER BY RAND() LIMIT 1" )
Thank you.
Comment