Using UNION for a single menu
Date: 1st March 2008 Category: mysql 1 comments
Working on an in-house content management system, I came across a problem regarding my use of unions in mysql. The system has a file that is assigned to a particular job or jobs. With a html menu, i would like the user to be able to change the relationship to any other active job inline with the job it belongs to. The objective was to display the current record selection regardless of it's status along with all other records with the status of active. The mysql Union of two select statements works to combined my results sets. What if the file did not have a job reference at all?
Mysql dates() functions overview
Date: 2nd July 2007 Category: mysql 4 comments
A very good overview of the Date and Time functions in Mysql from databasejournal.com ( from 2003). Here i have stuck just to the sql. Please see the link to read all the details.