say you have a table like this
CREATE TABLE mytable (
id int unsigned primary key auto_increment,
name varchar(50),
start datetime,
nextday date)
to query the date field you just add the criteria in mysql format
like
$sql = "SELECT * FROM mytable WHERE nextday='2005-01-26'";
if you want to use a php generated date then something like
$sql = "SELECT * FROM mytable WHERE nextday='" . date("Y-m-d", time()) . "'";
if you want to get search the date time field then you need to treat it as text so you are after anything that starts with 2005-01-26 the following chars are the time and are irrelevent. so something like
$sql = "SELECT * FROM mytable WHERE start LIKE '2005-01-26%'";
if you need the mysql date as a valid unix timestamp for use in php date functions then you would need to use an extra function in your select
$sql = "SELECT *, UNIX_TIMESTAMP(start) AS ustart FROM mytable WHERE startLIKE '2005-01-26%'";
does this cover everything you need?
