-
Recent Posts
Categories
Archives
Category Archives: php
Limit of 127 Points to Wrong Numeric Type
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
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
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
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