mysql using multiple condition in select

[Anon]

Hi, this doesnt seem to work (cant execute query) but it looks correct to me. What am i doin wrong:

$sql = "SELECT customer_id,title,first_name,last_name,product_purchased,purchase_date

FROM $table_name where (purchase_date BETWEEN '$start_date' AND '$end_date') AND (product_purchased = $product_purchased)
ORDER BY purchase_date DESC";

The start date and end dates are already inputed, and $product_purchased is also coming from previous form (i echo the variables so i know they are being carried over) thanks for any help

[Anon]

Right after that statment, do the following:

mysql_query($sql);
echo mysql_error();

read what it says, I'm betting that either something was mistyped (like you are missing $table_name or something) .. echo'ing the error is the best source of debugging you can get. If you are still stuck, post the error produced by that function as well as what the sql looks like (echo $sql).

Chris King