I have another Field in Category called C_Slug.
Any idea using a mysql command to copy the value of Name into C_Slug for each category listing?
(C_Slug field is empty)
~ ERASER
Free JavaScripts @ Insight Eye
Jan 16, 2008, 1:02 PM
Enthusiast (619 posts)
Jan 16, 2008, 1:02 PM
Post #1 of 3
Views: 2229
I have another Field in Category called C_Slug.
Any idea using a mysql command to copy the value of Name into C_Slug for each category listing?
(C_Slug field is empty)
~ ERASER
Free JavaScripts @ Insight Eye
Jan 17, 2008, 3:06 AM
Veteran / Moderator (18436 posts)
Jan 17, 2008, 3:06 AM
Post #2 of 3
Views: 2117
Hi,
Not quite sure what your trying to do :/
If you have 2 fields in the "Category" table, and you want to copy from C_Slug => Testing (for example), you could use:
(be sure to backup first though, in case it doesn't do what you want =))
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Not quite sure what your trying to do :/
If you have 2 fields in the "Category" table, and you want to copy from C_Slug => Testing (for example), you could use:
Code:
UPDATE glinks_Category SET C_Slug = Test;(be sure to backup first though, in case it doesn't do what you want =))
Hope that helps.
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!