close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Order by Product ID or Price

Thread began 12/26/2010 11:03 pm by jaa397769 | Last modified 12/27/2010 3:08 pm by jaa397769 | 990 views | 6 replies |

jaa397769

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

Sign in to reply to this post

Dani Chankhour

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

Sign in to reply to this post

jaa397769

No change

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

jaa397769

Made to correct directory

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/

Sign in to reply to this post

Ray BorduinWebAssist

That page is controlled by the page:

results_grid.php

Try making the same update to that page.

Sign in to reply to this post

jaa397769

Thats it, thank you for your help.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...