Tutorials > MySql Tutorials

Category Archives: MySql Tutorials

MySql is one of the most powerful open source relational databases available. It has become very popular and trusted by thousands of companies around the world. Here’s where you can find all my notes on using MySql.

Recursive Categories

Recursive Functions in PHP to Manage Single MySql Hierarchy Table

Posted on September 1, 2009 by Jesse Price

The recursive function is a necessary tool when it comes to creating very deep levels of categories and pages. These functions in fact are one of the best solutions in order to manage deep levels of relationships that are also … Read More »

Posted in MySql Tutorials, PHP Tutorials, Tutorials | 3 Comments
zipcodes-ss

MySql City, State, Zip, Latitude, Longitude Database

Posted on August 24, 2009 by Jesse Price

Just recently I needed a mysql database table that contained records for city, state, zip, latitude, and longitude coordinates. I needed a complete list of locations since one of my projects involved an ajax location auto populating script. While browsing … Read More »

Posted in MySql Tutorials, PHP Tutorials, Tutorials | 8 Comments