Category Archives: mysql

Calendar Pick-A-Date Scripts Reviewed

Posted on November 11, 2008 by LizzyFin

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

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

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