Got it. It's changing now.
I fixed it by changing the order to:
ORDER BY ratings DESC, numreviews DESC
And now it gives me the top rated items with the most reviews in descending order.
But, I seem to have run into another problem...It's not changing the products on the showcat page even though, from what I understand from showcat.php, it's calling the same function from pp-inc.php as index.php does. Am I right?