Category Archives: mysql

Calendar Pick-A-Date Scripts Reviewed

This week I needed to make a form where the user needed to enter two dates in order to produce a report with the selected start and end dates. What were my options? I considered writing my own php script … Continue reading

Posted in CSS, Software, mysql, php | Leave a comment

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

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