RE: manufacturers from id 10 to 30 how pls
Daemonj <[email protected]>
| Newsgroups | gmane.comp.web.oscommerce.general |
|---|---|
| Message-ID | <ab461c15b1a42e4a5c72d6ec814f68a1@osCommerce-Forums> |
This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=227102#227102
----------------------------------------------------------------
The following should do it:
[code]$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 and m.manufacturers_id => '20' and m.manufacturers_id <= '40' order by manufacturers_name");[/code]