manufacturers from id 10 to 30 how pls

[Salvo]

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

[Daemonj]

The following should do it:

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

[Salvo]

Thanks Jim

 

I will try that later ( I am not at my PC now)

 

Thanks

and I will report

[Salvo]

HI just tried the above and gives me this error

 

1064 - You have an error in your SQL syntax near '=> '20' and m.manufacturers_id <= '40' order by manufacturers_name' at line 1

 

any reason why?

[Salvo]

Correct Syntax

>= <=

 

m.manufacturers_id >= '2' and m.manufacturers_id <= '9'