Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

manufacturer list


Guest

Recommended Posts

Posted

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??

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...