Between Query in MYsql is not working
Posted: Fri Aug 31, 2007 4:19 am
Hello All,
I have this query which when written does not execute, PHPMyAdmin says it to be an error.
where $start_date = 2007-08-15
$end_date = 2007-08-29
This query does not work.. can i know where am i going wrong?
Thanks & Regards,
Dream2rule
I have this query which when written does not execute, PHPMyAdmin says it to be an error.
Code: Select all
SELECT * FROM user_ip_tracking ORDER BY ip_id WHERE date_of_access BETWEEN '$start_date' AND '$end_date'$end_date = 2007-08-29
This query does not work.. can i know where am i going wrong?
Thanks & Regards,
Dream2rule