Order by Product ID or Price

I have made the proper edit to this string:

mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);
$query_WADAProducts = "SELECT *, coalesce((select ps4_productoptions.GroupingID from ps4_productoptions WHERE ps4_productoptions.ProductID = ps4_products.ProductID limit 1),ps4_products.ProductID) AS GroupingID FROM ps4_products WHERE ProductLive = 1 AND (ProductStartDate IS NULL OR ProductStartDate <= CURDATE()) AND (ProductEndDate IS NULL OR ProductEndDate >= CURDATE()) GROUP BY GroupingID ORDER BY ProductName";

which now reads:

mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);
$query_WADAProducts = "SELECT *, coalesce((select ps4_productoptions.GroupingID from ps4_productoptions WHERE ps4_productoptions.ProductID = ps4_products.ProductID limit 1),ps4_products.ProductID) AS GroupingID FROM ps4_products WHERE ProductLive = 1 AND (ProductStartDate IS NULL OR ProductStartDate <= CURDATE()) AND (ProductEndDate IS NULL OR ProductEndDate >= CURDATE()) GROUP BY GroupingID ORDER BY ProductID";

Yet the products still do not go in the proper order on the page returned for the results.

If ORDER BY ProductID means to select from that table, then why are the results still not showing up.

The file I changed is stored in /webassist/plugins/catalog/

Is this where the file is found? is this the file products_results.php is calling?

Please advise on what was done wrong, my products are all out of whack.

Thanks

In the Catalog folder, try making the changes to the results.php file that is in the basic folder.

I did, and there was no change to the layout of the products. Is ProductID the way I should go, or ProductPrice since I want lowest to highest?

It seems like the updates you made would work... are you sure you updated the file in /webassist/plugins/ not the file in install/webassist/plugins ?

It would seem like ProductPrice would be the field to use if you want it ordered by price.

I noticed when uploading the file through filezilla, that the file I edited on my machine would be for example 15,800kb when uploaded to server shows as what it was previous lets say 15,600. I thought maybe there was a permissions issue but I checked that and it was fine, I also download the file again opened it Dreamweaver and the line I changed was changed, but no matter what I do the products don't order differently.

Here is a link to the site:
please take a look at any category from the menu and see how the dollar amounts are all out of whack.

shop2/

That page is controlled by the page:

results_grid.php

Try making the same update to that page.

Thats it, thank you for your help.