[Solved] How to grab bunch of dates that are these days?

by


If you have a DATE MySQL object, you could use the DAYNAME function, and search by that:

SELECT * FROM mytable WHERE DAYNAME(date) = 'Monday'

In PHP/PDO-land, that would be:

foreach($db->query("SELECT * FROM mytable WHERE DAYNAME(date) = 'Monday'") as $row) {
    // do stuff with $row
}

0

solved How to grab bunch of dates that are these days?