Having Clause >= date

[tecdesign]

I tried the following mysql query and it is not working

 

$result = mysql_query("select * from $bank where username = '$username' ORDER BY $order DESC HAVING date_stamp >= $from AND date_stamp <= $to");

 

Any Suggestions

[artacus]

1) easier to read if you use between and you need to quote your dates,

2) don't store each $bank in its own table, store them all in 1 table with a bank field.

3) Can't use HAVING unless there is a group by clause,

 

SELECT *
FROM banks
WHERE bank_name = '$bank' AND username = '$username'
AND date_stamp BETWEEN '$to' AND '$from'
ORDER BY $order DESC