Guest Posted October 23, 2002 Posted October 23, 2002 I have put some manufacturers in the list. about 10 . But only shows me 6 in the dropdown-menu. When I use the other option to display the manufacturers, it shows them all. What could be the reason??
Ajeh Posted October 23, 2002 Posted October 23, 2002 In the /catalog/includes/boxes/manufactures.php do you have anything in the select statement saying something like this: // BOF: WebMakers.com Added: Show Manufacturers with products only // Original Code: $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name"); $manufacturers_query = tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where m.manufacturers_id=p.manufacturers_id order by manufacturers_name"); // EOF: WebMakers.com Added: Show Manufacturers with products only The where statement in there says there has to be a product to display the manufacture.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.