Limit of 127 Points to Wrong Numeric Type

Posted on 7 October 2008 by LizzyFin

If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!Sometimes the simple things evade us when we’re caught up in the details. Thank goodness for manuals.
It turns outs that the numeric type that you select for your database variables matters greatly - DUH!
I had an occurrence last week [...]

Round Numbers to Next Whole Number in PHP

Posted on 17 September 2008 by LizzyFin

Time for a new php function, ceil().
A client needed to record the hours spent in particular activities by each member. The number of hours spent in assigned activities were to be entered in whole numbers, where partial hours were rounded up to the nearest hour. So, if someone spent an hour and twenty minutes on [...]

Left Joins Produce Data Reports Using All Rows of One Table

Posted on 1 May 2008 by LizzyFin

A client needed to have several reports created that indicate the various training sessions and certifications that each member has achieved. Producing the reports required collating data from several mysql tables and that made the queries a little complex.
SELECT statements were used for the most part which combined data from up to nine different mysql [...]