[RESOLVED] Date problem in PHP

[wwwfilmfilercom]

I would like to send an email out on a specific date (I will use cronjobs for this) and I'm testing this.

Im trying to set the date and therefore send emails for records which match this date.

$d="2008-12-04";

However, when I echo that out it only returns '2008'. I can't think why, what is going on here??

[the182guy]

That shouldn't echo '2008'.

Can you show the rest of your code?

[wwwfilmfilercom]

Here's everything:

$d="2008-12-04";

/* GET ALL REMINDERS FOR THIS DATE */
$query="SELECT reminderid, callid FROM reminder WHERE duedate=? ORDER BY reminderid";
$stmt = $mysqli->prepare($query);
$stmt->bind_param('i', $d); 
$stmt->execute(); 
$stmt->bind_result($reminderid, $callid);
$stmt->store_result();
if ($stmt->num_rows>0) {
while ($stmt->fetch()) {
// DO STUFF
}
} else {
	echo "nothing happened ";
	echo $d;
}

The only output I see is:

nothing happened 2008

[wwwfilmfilercom]

Fixed::

Problem was here

('i', $d);

since $d should be a string not integer.