I've been able to get this to work great (thanks!) but was wondering if there was something I could modify so that it is:
1. Independent of the category page it is currently being displayed on and instead
2. Shows only random products from a category I specify, for example, I just want it to show products in "Category D" which has a categoryid of 8, no matter what page it's on.
I assume I need to edit random.php and the SQL query, but I don't know how. Any help would be appreciated.
Thank you