I run a classifields market with wsnlinks 3.3.15. During searching on the manual I found { LINKDESCRIPTION[x] } which reduces the displayed description to x characters.
Because I dosen't now the function before I made a new field which was called longdescription and let the users fill out both fields. This field is now not needed anymore.
Now I have 1000 classifields and I want to move the content for each (link) form the fild linklongdescription to the field linkdescription and overwrite the content of linkdescription.
Please can somebody provide the exact mysql command for that in detailed form like example:
I presume you mean description, since there isn't a linkdescription field. Not sure if you mean linklongdescription or actually just longdescription but I'll assume here you mean longdescription:
UPDATE wsnlinks_links SET description = longdescription;
Are you sure though that it wouldn't be better to keep both fields? The first words of a long description aren't always the best short summary.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on phpmyadmin move content
Member
Usergroup: Customer
Joined: Oct 23, 2005
Total Topics: 21
Total Comments: 27
I run a classifields market with wsnlinks 3.3.15. During searching on the manual I found { LINKDESCRIPTION[x] } which reduces the displayed description to x characters.
Because I dosen't now the function before I made a new field which was called longdescription and let the users fill out both fields. This field is now not needed anymore.
Now I have 1000 classifields and I want to move the content for each (link) form the fild linklongdescription to the field linkdescription and overwrite the content of linkdescription.
Please can somebody provide the exact mysql command for that in detailed form like example:
UPDATE wsnlink_settings SET content=''...
Thank you, Sebastian
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I presume you mean description, since there isn't a linkdescription field. Not sure if you mean linklongdescription or actually just longdescription but I'll assume here you mean longdescription:
UPDATE wsnlinks_links SET description = longdescription;
Are you sure though that it wouldn't be better to keep both fields? The first words of a long description aren't always the best short summary.