Blog

Update mysql_query to PDO

Jun 1, 2014, 12:22 PM

A guide on updating your code that used the PHP MySQL library to PDO (PHP Data Objects) for MySQL.

MySQL Find Most Recent/Largest Record Per Group

Jan 23, 2014, 1:22 PM

A guide to finding the largest or most recent value in a group of values in a MySQL or SQL table.

SQL: Relating Data using Inner Join

Jan 16, 2014, 6:30 PM

A brief guide on using SQL Inner Join to relate data in multiple tables.

SQL: Find Items in Table A Not in Table B

Jan 14, 2014, 4:48 PM

A guide on finding records that exist in one table that do not have a corresponding record in another table.

MySQL Find and Replace Values

Jan 1, 2014, 8:22 PM

A guide on how to search and replace values in MySQL via query