Category Archives: php

Limit of 127 Points to Wrong Numeric Type

Posted on October 7, 2008 by LizzyFin

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 … Continue reading →

Posted in mysql, php | Leave a comment

Round Numbers to Next Whole Number in PHP

Posted on September 17, 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 … Continue reading →

Posted in php | Leave a comment

Left Joins Produce Data Reports Using All Rows of One Table

Posted on May 1, 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 … Continue reading →

Posted in mysql, php | Leave a comment

Null Values Handled Nicely with the PHP Error Suppression Operator

Posted on April 29, 2008 by LizzyFin

Working on some database reports for a client’s membership roster and such, I came across a simple solution in handling some types of errors. Error messages filled a column in one report that should have output whether certain requirements were … Continue reading →

Posted in mysql, php | Leave a comment