TAV1702 Posted January 7, 2011 Report Share Posted January 7, 2011 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 Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 7, 2011 Author Report Share Posted January 7, 2011 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 Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 7, 2011 Author Report Share Posted January 7, 2011 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.