SELECT * FROM bean_overtime_availability WHERE `startDateTime` >= DATE(NOW()) AND `available` = 1;
One project that John inherited was a fairly simple web application that tracked overtime. Simple, that is, from the front end. The back end PHP code was responsible for querying a MySQL database with queries similar to this:
via CodeSOD: Simple SQL:
Truly wonderful code generator on this one. Made my morning ;-)
