Between Syntax

[Guest_imported]

Hi, I've got this code:

$number_of_records=mysql_query("SELECT * FROM details WHERE category2='south' and price = BETWEEN '$pricerangel' and '$pricerangeh'"
$number_of_records_in_table = mysql_num_rows($number_of_records);

gives Warning: Supplied argument is not a valid MySQL result resource in etc etc. It's the BETWEEN statement thats causing the trouble but the mysql manual doesn't make the syntax clear to me. I'm a bit lost here.

Many thanks for any pointers.

 

[piti]

the BETWEEN clause has following syntax

column BTEWEEN min_value AND max_value

so your query should be

SELECT * FROM details WHERE category2='south' and price BETWEEN '$pricerangel' and '$pricerangeh'

hope that helps