Sorry if this has been brought up before and I have searched and searched most of the day and have came up empty handed on every attempt.
I need to know if there is a sql query I can run in phpmyadmin to make the News titles a bit longer. Now it chops words off right in the middle. I think it has something to do with vchar or something like that. Anyone show me the way?
Thanks in advance either way.
Ray
Would it be this per chance?
ALTER TABLE `phpvms_news` CHANGE `subject` `email` VARCHAR( 50 ) NOT NULL
The vchar is currently 30.
I am not real good at sql but am learning. I just took a wild stab at that one.
**EDIT**
Ok I tried that and it and it deleted my subject line. Now I need to figure out how to readd it and then update the char to 50 instead of 30
Ok I’m marking this one solved.
I went ahead and ran another query that went like this
ALTER TABLE phpvms_news ADD subject VARCHAR(50) AFTER email
It added my subject line back and updated my subject line to 50 characters instead of 30. Hard lesson to learn but I got it fixed.