MySQL Affected Rows vs Rows Matched
PHP’s mysql_affected_rows() is used to get the number of rows that were “affected” by the last query executed using mysql_query(). Therefore, an UPDATE query that set the value of a …
PHP Date Format vs MySQL Date Format
Today I had the pleasure of discovering (through an hour of annoying debugging) that PHP’s formatting of dates is not exactly identical to MySQL’s date formatting. I was using a …