PHP - How to recognize a date string from the mysql DB

Asked Dec 14 '15 at 20:06

Active Dec 14 '15 at 20:06

Viewed 19 times

The query below will only display the first 5 entries in the DB. I'm looking to get the next 5 based on today's date. The dates are stored in the DB in this format, "2009-10-19'. I don't think it understands the date stored the way it is?

//GET TODAYS DATE
$now = date('Y-m-d');

//GET EVENTS
$sql17 = "SELECT * FROM approved WHERE 'date_begin' > '$now' LIMIT 5";
$result17 = $link3->query($sql17);

if ($result17->num_rows > 0) {
while($row17 = $result17->fetch_assoc()) {

$originalDate = $row17["date_begin"];
$newDate = date("M-d-Y", strtotime($originalDate));

echo $row17["requiredeventname"].' - '.$newDate.', '.$row17["requiredcity"].' '.$row17["state"].' - FIND OUT MORE<br>';

}
} else {
echo "Not Found";
}

asked Dec 14 '15 at 20:06

GraphicsGuy

Which database are you using? – greenmarker Dec 14 '15 at 20:10
1

are you looking to use this as a column or string literal? `WHERE 'date_begin'`. If it's a column, remove the quotes. MySQL should be throwing you an error for it. – Funk Forty Niner Dec 14 '15 at 20:17
mysql is the database name, just trying to echo it out – GraphicsGuy Dec 14 '15 at 20:17
removing the quotes fixed it. Thank you. I thought for sure I had tried it both ways. I usually do. – GraphicsGuy Dec 14 '15 at 20:21
You're welcome. There was a duplicate, for which I closed the question with. *Cheers* – Funk Forty Niner Dec 14 '15 at 20:23

PHP - How to recognize a date string from the mysql DB

0 Answers0