Go Back   PHP Link Directory Forum > PHP Link Directory (phpLD) > Mods and contribution Discussion

Mods and contribution Discussion This forum is only for discussion of modding phpLD. For specific mod releases, please see the appropriate forum.

Closed Thread
 
topic widgets
Old 01-12-2006   #1
tarheit
Supporter
 
Join Date: Jan 2006
Location: Ohio
Posts: 26
Default State Subcategories

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.

Code:
Content visible to registered users only.
-Tim

Last edited by David; 03-21-2009 at 10:48 PM.
tarheit is offline  
Old 01-13-2006   #2
anylink
 
Join Date: Dec 2005
Posts: 7
Default

very nice thanks a load!
anylink is offline  
Old 06-02-2006   #3
DelMarSurf
Supporter
 
Join Date: May 2006
Posts: 55
Default

YEA! This works perfectly. Thanks!!!
DelMarSurf is offline  
Old 06-02-2006   #4
anon
Supporter
 
anon's Avatar
 
Join Date: Feb 2006
Location: As far from you as humanly possible!
Posts: 2,860
Default

Code:
Content visible to registered users only.
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
anon is offline  
Old 10-29-2006   #5
montytx
Supporter
 
Join Date: Feb 2006
Posts: 15
Default

Does anyone have a state/ city dump they could share?
__________________
Some of my sites....
Dallas Directory
roofing contractor
montytx is offline  
Old 05-28-2007   #6
johnbmtl
 
Join Date: May 2007
Location: Blainville (Montreal area), QC. Canada
Posts: 21
Default

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
johnbmtl is offline  
Old 06-22-2007   #7
searchangle
 
Join Date: May 2007
Posts: 63
Default I get the Following Error - CAN YOU HELP???

#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
__________________
______________________________________________
My Site:
Free SEO Tools Directory - SEO Tool Land
searchangle is offline  
Old 08-28-2007   #8
omakad
Supporter
 
Join Date: Jul 2007
Posts: 21
Default

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?
omakad is offline  
Old 08-28-2007   #9
Mr_Bill
Supporter
 
Join Date: May 2007
Posts: 159
Default

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

Code:
Content visible to registered users only.
Mr_Bill is offline  
Old 08-29-2007   #10
omakad
Supporter
 
Join Date: Jul 2007
Posts: 21
Default

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.
omakad is offline  
Closed Thread

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
topic widgets



All times are GMT +1. The time now is 06:00 PM.


Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.