Using PowerStore SQL
Thank you for your quick response and your recognition of the error cause. I am using the Product_Results.php page that comes with PowerStore 2. The only change was to add in the "ORDER BY products.ProductName ASC" at the end of the query string starting at line 155. I added this in based on the forum post referenced in the original message.
How do I fix the SQL in the PowerStore 2 provided page ?