by Cube Websites | Dec 30, 2011 | MySQL, PHP
Introduction When working with databases, you may want a table structure which allows your record to have a parent record (heirachical recordset). In simple scenarios it’s easy enough to simply have a parent_id column. However, for displaying the entire tree...
by Cube Websites | Dec 22, 2009 | Guides, MySQL, Software
Today was a different kind of problem. Working on a PHP web application on localhost using XAMPP, I was required to import a massive list of geographical locations into a MySQL database. The problem was, the .txt file with the data was over 700MB!! Obviously any...
