manufacturers from id 10 to 30 how pls

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=226971#226971
----------------------------------------------------------------

HI all

I have the below code that retrieve the manufacturers and show them
by name order..

Question:
How do you search manufacturers from id 20 to id 40 ?

thanks

 $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");