Description
Details
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.
Structure
Details
The list inserts values in the following fields of the phpld directory categiry table:
- ID
- TITLE
- CACHE_TITLE
- TITLE_URL
- CACHE_URL
- PARENT_ID
- STATUS
- META_KEYWORDS
Others
Additional Information
| File Format | MS Excel 2003 Spread Sheet, MySQL Script |
|---|---|
| Format Details |
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. 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 |
| Keywords | phpld, phpld4, category, categories, dump |
| Key Phrases | us states and cities, us cities, phpld category dump, phpld4 categories, categories dump phpld, web directory categories, web directory, free categories dump |
| Specific Terms and Condition | 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 [email protected]. Thank you. |
Sample
Details
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');
Tags
Reviews
Payment
