This is a list of 6,300+ entries to categorize US states and cities to be used in a Php Link Directory (phpLD). The list is compatible with phpLD version 3.x to version 4.x. That is the list and associated SQL statements will work for all phpLinkDirectory versions from 3.0 to 4.1, versions in between and beyond (that is version 4.x). The categories come in the form of SQL script. The script is ready to be run on any SQL browser or tool such as MySQL query browser.

The list of categories can be installed either as a new category structure of a new php link directory or to append category structure of an existing php link directory.

The SQL script is a set of SQL INSERT commands that will automatically create the category structure for your brand new phpLD directory. All you need is to load the script contents on to your tool (e.g. MySQL QueryBrowser) script window and execute. The detail loading or installation instruction is included in the package.

Data Format:

The Excel worksheet provided in the package is formula driven. The IDs of category can be started from 1 (for a new directory set up) or any sequence (to append the categories to an existing directory structure). It generates list as a set of SQL INSERT Command statements doing the following:

a) Insert records in the PLD_CATEGORY table
b) Instruction to insert a record in the PLD_CATEGORY_SEQ table

Data Columns:

The list inserts values in the following fields:

• ID
• TITLE
• CACHE_TITLE
• TITLE_URL
• CACHE_URL
• PARENT_ID
• STATUS
• META_KEYWORDS

Data Example:

INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (197, 'Benson', 'Arizona: Benson', 'Benson', 'index.php?c=197', 4, 2, 'Benson');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (198, 'Bisbee', 'Arizona: Bisbee', 'Bisbee', 'index.php?c=198', 4, 2, 'Bisbee');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (199, 'Buckeye', 'Arizona: Buckeye', 'Buckeye', 'index.php?c=199', 4, 2, 'Buckeye');
INSERT INTO `PLD_CATEGORY` (`ID`, `TITLE`, `CACHE_TITLE`, `TITLE_URL`, `CACHE_URL`, `PARENT_ID`, `STATUS`, `META_KEYWORDS`) VALUES (200, 'Bullhead City', 'Arizona: Bullhead City', 'Bullhead_City', 'index.php?c=200', 4, 2, 'Bullhead City');

Keywords:

us states and cities, us cities, phpld category dump, phpld4 categories, phpld, phpld4, category, categories, dump, categories dump phpld, web directory categories, web directory, free categories dump

*************************************************
phpLD v3.x v4.x Category SQL Dump for US States and Cities
*************************************************
Is an eBuisnessGems Product
Copyright © eBuisnessGems.com, 2011

Unauthorized copying, distribution and use of this product is strictly prohibited.
You can purchase and download this product from www.eBusinessGems.com.
You can use this product for your own purpose. You are not entitled to resell it.
If you find this product being distributed or sold from any other store, please
immediately inform sales@eBusinessGems.com. Thank you.