"All The US States" Mod
1.0.7.x
|
| Price: |
USD 0 |
| Module Type: |
Other Modules |
| Version: |
1.0.7.x |
| Supported?: |
Yes (free) |
|
Module Description:
|
|
|
This script will help you to populate all the US states into your Locations dropdown without manual input. Just upload it to your PMR root folder via ftp and run in your browser (please note that all other records in the locations table will be removed)
<?php
include ("./config.php");
include ("./defaults.php");
mysql_query("DELETE FROM " . LOCATIONS_TABLE . "");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (1, 'Alabama')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (2, 'Alaska')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (3, 'Arizona')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (4, 'Arkansas')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (5, 'California')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (6, 'Colorado')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (7, 'Connecticut')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (8, 'Delaware')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (9, 'District of Columbia')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (10, 'Florida')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (11, 'Georgia')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (12, 'Hawaii')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (13, 'Idaho')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (14, 'Illinois')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (15, 'Indiana')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (16, 'Iowa')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (17, 'Kansas')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (18, 'Kentucky')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (19, 'Louisiana')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (20, 'Maine')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (21, 'Maryland')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (22, 'Massachusetts')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (23, 'Michigan')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (24, 'Minnesota')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (25, 'Mississippi')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (26, 'Missouri')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (27, 'Montana')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (28, 'Nebraska')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (29, 'Nevada')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (30, 'New Hampshire')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (31, 'New Jersey')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (32, 'New Mexico')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (33, 'New York')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (34, 'North Carolina')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (35, 'North Dakota')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (36, 'Ohio')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (37, 'Oklahoma')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (38, 'Oregon')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (39, 'Pennsylvania')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (40, 'Rhode Island')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (41, 'South Carolina')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (42, 'South Dakota')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (43, 'Tennessee')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (44, 'Texas')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (45, 'Utah')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (46, 'Vermont')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (47, 'Virginia')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (48, 'Washington')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (49, 'West Virginia')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (50, 'Wisconsin')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (51, 'Wyoming')");
mysql_query("INSERT INTO " . LOCATIONS_TABLE . " (id, name) VALUES (52, 'Outside the US')");
echo "Records Inserted";
?>
|
Downloaded / Viewed: 502
Submission Date: 09-15-2007
Last Update: --
|
|
|
|
