[RESOLVED] Date problem in PHP

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??

That shouldn't echo '2008'.

Can you show the rest of your code?

Here's everything:

$d="2008-12-04";

Code:

---

/* 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:

Quote:

---

nothing happened 2008

---

Fixed::

Problem was here

Code:

---

('i', $d);

---

since $d should be a string not integer.