RE: how about fixing some code like this?

Wayne Luke <[email protected]> 22 Jul 2003 06:35:09 -0000
Newsgroups gmane.comp.web.oscommerce.suggestions
Message-ID <fa93dff2d168a89a1aecb80677612a20@osCommerce-Forums>
This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=199960#199960
----------------------------------------------------------------

No... It should order the records retrieved by products_id...

productid_1 record1
productid_1 record2
productid_1 record3

productid_2 record1
productid_2 record2
productid_2 record3

Group By is to allow you to group records by a common field. Any singular field should be automatically joined to each record that it fits. Try the exact query that you are referring to in phpMyAdmin and look at the results..