CodeSOD: Simple SQL

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 😉

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s