This works:
$result = mysql_query("SELECT * FROM plan WHERE begin BETWEEN '2010-09-01' AND '2010-09-30'") or die(mysql_error());
I need some version of this to work where begin and end are currently timestamped columns in my table:
$result = mysql_query("SELECT * FROM plan WHERE date("Y-m-d") BETWEEN begin AND end") or die(mysql_error());
What's the correct form? I haven't been able to tease it out of the documentation.
selecting a date in a date range
Moderator: General Moderators
- DigitalMind
- Forum Contributor
- Posts: 152
- Joined: Mon Sep 27, 2010 2:27 am
- Location: Ukraine, Kharkov
Re: selecting a date in a date range
curdate() ?
Re: selecting a date in a date range
You're close. MYSQL Date functions.
Thanks,
Niche1
Thanks,
Niche1