GIGJ.COM
welcome to my space
X
Welcome to:gigj.com
Search:  
NAVIGATION - HOME
State Subcategories
Published by: jane 2009-01-07
  • For those wanting to add states as categories, I found it much easier to run the following query in phpMyAdmin rather than create each manually in the admin area. Just search the following code for 117 and replace it with the id of the category the states should fall under. Then run the code in phpMyAdmin. I found it saved a lot of time when adding sub categories to several different main categories.


    INSERT INTO PLD_CATEGORY VALUES ('','Alabama','Alabama',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Alaska','Alaska',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Arizona','Arizona',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Arkansas','Arkansas',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','California','California',NULL,117,2,NOW(),0,0 ,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Colorado','Colorado',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Connecticut','Connecticut',NULL,117,2,NOW(),0 ,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Delaware','Delaware',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Florida','Florida',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Georgia','Georgia',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Hawaii','Hawaii',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Idaho','Idaho',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Illinois','Illinois',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Indiana','Indiana',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Iowa','Iowa',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Kansas','Kansas',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Kentucky','Kentucky',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Louisiana','Louisiana',NULL,117,2,NOW(),0,0,0 );
    INSERT INTO PLD_CATEGORY VALUES ('','Maine','Maine',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Maryland','Maryland',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Massachusetts','Massachusetts',NULL,117,2,NOW (),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Michigan','Michigan',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Minnesota','Minnesota',NULL,117,2,NOW(),0,0,0 );
    INSERT INTO PLD_CATEGORY VALUES ('','Mississippi','Mississippi',NULL,117,2,NOW(),0 ,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Missouri','Missouri',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Montana','Montana',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Nebraska','Nebraska',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Nevada','Nevada',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','New Hampshire','New_Hampshire',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','New Jersey','New_Jersey',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','New Mexico','New_Mexico',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','New York','New_York',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','North Carolina','North_Carolina',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','North Dakota','North_Dakota',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Ohio','Ohio',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Oklahoma','Oklahoma',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Oregon','Oregon',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Pennsylvania','Pennsylvania',NULL,117,2,NOW() ,0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Rhode Island','Rhode_Island',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','South Carolina','South_Carolina',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','South Dakota','South_Dakota',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Tennessee','Tennessee',NULL,117,2,NOW(),0,0,0 );
    INSERT INTO PLD_CATEGORY VALUES ('','Texas','Texas',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Utah','Utah',NULL,117,2,NOW(),0,0,0);
    INSERT INTO PLD_CATEGORY VALUES ('','Vermont','Vermont',NULL,117,2,NOW(),0,0,0) ;
    INSERT INTO PLD_CATEGORY VALUES ('','Virginia','Virginia',NULL,117,2,NOW(),0,0, 0);
    INSERT INTO PLD_CATEGORY VALUES ('','Washington','Washington',NULL,117,2,NOW(),0,0 ,0);
    INSERT INTO PLD_CATEGORY VALUES ('','West Virginia','West_Virginia',NULL,117,2,NOW(),0,0,0);
    LibGuides: CAREER AND JOB HUNTING - SUBCATEGORIES::
    LibGuides. CAREER AND JOB HUNTING. SUBCATEGORIES. 4 - Occupational schools listed by state and by program of instruction; Vol.
    http://libguides.uwstout.edu/content.php?pid=16293&sid=109738    HOME
    INSERT INTO PLD_CATEGORY VALUES ('','Wisconsin','Wisconsin',NULL,117,2,NOW(),0,0,0 );
    INSERT INTO PLD_CATEGORY VALUES ('','Wyoming','Wyoming',NULL,117,2,NOW(),0,0,0) ;


    -Tim
    www.honeyrunapiaries.com


  • If you are trying to use this for v.3.2 you could try this


    INSERT INTO `PLD_CATEGORY` VALUES (1, 'Alabama','Alabama', 'alabama', 'alabama/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (2, 'Alaska','Alaska', 'alaska', 'alaska/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (3, 'Arizona','Arizona', 'arizona', 'arizona/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (4, 'Arkansas','Arkansas', 'arkansas', 'arkansas/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (5, 'California','California', 'california', 'california/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (6, 'Colorado','Colorado', 'colorado', 'colorado/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (7, 'Connecticut','Connecticut', 'connecticut', 'connecticut/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (8, 'Delaware','Delaware', 'delaware', 'delaware/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (9, 'Florida','Florida', 'florida', 'florida/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (10, 'Georgia','Georgia', 'georgia', 'georgia/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (11, 'Hawaii','Hawaii', 'hawaii', 'hawaii/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (12, 'Idaho','Idaho', 'idaho', 'idaho/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (13, 'Illinois','Illinois', 'illinois', 'illinois/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (14, 'Indiana','Indiana', 'indiana', 'indiana/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (15, 'Iowa','Iowa', 'iowa', 'iowa/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (16, 'Kansas','Kansas', 'kansas', 'kansas/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (17, 'Kentucky','Kentucky', 'kentucky', 'kentucky/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (18, 'Louisiana','Louisiana', 'louisiana', 'louisiana/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (19, 'Maine','Maine', 'maine', 'maine/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (20, 'Maryland','Maryland', 'maryland', 'maryland/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (21, 'Massachusetts','Massachusetts', 'massachusetts', 'massachusetts/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (22, 'Michigan','Michigan', 'michigan', 'michigan/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (23, 'Minnesota','Minnesota', 'minnesota', 'minnesota/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (24, 'Mississippi','Mississippi', 'mississippi', 'mississippi/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (25, 'Missouri','Missouri', 'missouri', 'missouri/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (26, 'Montana','Montana', 'montana', 'montana/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (27, 'Nebraska','Nebraska', 'nebraska', 'nebraska/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (28, 'Nevada','Nevada', 'nevada', 'nevada/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (29, 'New Hampshire','New-Hampshire', 'new-hampshire', 'new-hampshire/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (30, 'New Jersey','New-Jersey', 'new-jersey', 'new-jersey/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (31, 'New Mexico','New-Mexico', 'new-mexico', 'new-mexico/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (32, 'New York','New-York', 'new-york', 'new-york/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (33, 'North Carolina','North-Carolina', 'north-carolina', 'north-carolina/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (34, 'North Dakota','North-Dakota', 'north-dakota', 'north-dakota/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (35, 'Ohio','Ohio', 'ohio', 'ohio/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (36, 'Oklahoma','Oklahoma', 'oklahoma', 'oklahoma/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (37, 'Oregon','Oregon', 'oregon', 'oregon', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (38, 'Pennsylvania','Pennsylvania', 'pennsylvania', 'pennsylvania/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (39, 'Rhode Island','Rhode-Island', 'rhode-island', 'rhode-island/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (40, 'South Carolina','South-Carolina', 'south-carolina', 'south-carolina/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (41, 'South Dakota','South-Dakota', 'south-dakota', 'south-dakota/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (42, 'Tennessee','Tennessee', 'tennessee', 'tennessee/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (43, 'Texas','Texas', 'texas', 'texas/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (44, 'Utah','Utah', 'utah', 'utah/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (45, 'Vermont','Vermont', 'vermont', 'vermont/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (46, 'Virginia','Virginia', 'virginia', 'virginia/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (47, 'Washington','Washington', 'washington', 'washington/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (48, 'West Virginia','West-Virginia', 'west-virginia', 'west-virginia/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (49, 'Wisconsin','Wisconsin', 'wisconsin', 'wisconsin/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');
    INSERT INTO `PLD_CATEGORY` VALUES (50, 'Wyoming','Wyoming', 'wyoming', 'wyoming/', '', 0, 2, '2007-08-28 14:47:25', 0, 0, 0, '', '');


  • very nice thanks a load!


  • #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO PLD_CATEGORY VALUES ('','Alaska','Alaska',NULL,3,2,NOW(),0,0,0); ' at line 1


  • Do we still need to specify the category ID anywhere in this code? and if yes then where? I'm sorry I'm retarded about running mySQL inquires. Thanks.


  • YEA! This works perfectly. Thanks!!! :D


  • Does anyone have a state/ city dump they could share?


  • I'm getting the same error. I've run this code before for the rest of my cat's but now it's not working any more. Has anyone figured out what is going on?


  • When I try running this on the database (using 3.2), I get the following error:

    "#1136 - Column count doesn't match value count at row 1 "

    Is this because of something that I am not doing correctly or has the database changed since this was posted?

    John


  • YEA! This works perfectly. Thanks!!! :D
    Remember, i never steer anyone wrong, and like i told you, this breaks things in terms of adding more new categories. Step 2 is to now find my post to fix what's been hacked up by the original posters database additions.

    Rob





    • Nortel Unveils Vision, Strategy for Israeli High-Performance Net
    Busy Friday Leads to Strong Close for Net Stocks
    You are looking at:gigj.com's State Subcategories, click gigj.com to home
    #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about State Subcategories , Please add it free.
  • person in charge of multimedia messaging at qwest
  • language learning in the womb
  • software for pizza delivery
  • automobile ownership
  • art appraisal
  • how many people bathe at night
  • ideas for a logo
  • applying for research position
  • increase intelligence
  • affordable out of print book
  • upper labial frenulum in primates
  • plastic extrusion extrusion foaming of pp profiles
  • cost of minimum wage employee

  • name top level domain
  • child 39 s 2nd language
  • old uk credit card debt statute of limitations and how to resolve the issue
  • who sells electronic signature digital signature solutions
  • irs rules and regulations
  • fl restaurant owner liability to customers and employees
  • who an e mail address belongs to
  • toxic mold litigation
  • kiosk software
  • medical insurance coverage
  • intermidate to advanced japanese conversation websites
  • info on artist tanner intersection i and ii
  • conde nast reader service
  • comparison shop for dedicated web hosting
    •  Homepage | Add to favorites | Contact us | Exchange links | LOGIN | Site map | 
    Copyright© 2008 gigj.com        Site made:CFZ