Lambneck Posted June 4, 2009 Share Posted June 4, 2009 Hi, Can someone tell me how I can edit my blog entries? They are stored in a mysql data base row mediumblob data type. I'm not sure if this should be a php question or not. Is there a simple way to edit textual content in a database? Thanks! Quote Link to comment Share on other sites More sharing options...
dadamssg Posted June 4, 2009 Share Posted June 4, 2009 yeah....there is a way but you have to know how to access your database. Database username, password, then have to write some php to get out and put it back in...or if you have phpMyAdmin for the site you could access it that way Quote Link to comment Share on other sites More sharing options...
Lambneck Posted June 4, 2009 Author Share Posted June 4, 2009 oh man, i have phpadmin but i don't see anything in it that allows me to open data from a medium blob data type. Is there a better data type for what I am trying to do? Quote Link to comment Share on other sites More sharing options...
dadamssg Posted June 4, 2009 Share Posted June 4, 2009 well you have to update that database table cell with sql. somethin like UPDATE tablename SET blogentry = 'youreditedblogentry' where blogentry = '345' '345' would be the blog entry id number that it has in the database. Quote Link to comment Share on other sites More sharing options...
Lambneck Posted June 4, 2009 Author Share Posted June 4, 2009 well you have to update that database table cell with sql. somethin like UPDATE tablename SET blogentry = 'youreditedblogentry' where blogentry = '345' '345' would be the blog entry id number that it has in the database. I think I understand but what is: blogentry = 'youreditedblogentry' ? Quote Link to comment Share on other sites More sharing options...
dadamssg Posted June 4, 2009 Share Posted June 4, 2009 blogentry would be the name of the column that holds all your entries...not sure what it could be called...your medium blob data type's name. and then set it equal to whatever your updated blog is...for example First blog... My dog at my homework yesterday. Updated blog... My dog at my homework a week ago. So say if your column that holds the blog entries is called 'entries' it would be something like UPDATE tablename SET entries = 'My dog at my homework a week ago.' where blogentry = '345' and 'tablename' would obviously be whatever your database table is called Quote Link to comment Share on other sites More sharing options...
Lambneck Posted June 4, 2009 Author Share Posted June 4, 2009 Ok thanks a lot! So one last question. This code is entered in the sql section of phpmyadmin? (Sorry new to this. ) Quote Link to comment Share on other sites More sharing options...
dadamssg Posted June 4, 2009 Share Posted June 4, 2009 yup 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.