mATOK Posted August 15, 2006 Share Posted August 15, 2006 Hello out there!I have a DB that I am going to be populationg via a form that I am going to create in html/php.I have 4 fields in my DB that are of type mediumtxt. When I use MySQL consol manager i am prompted to save and name my txt files and then to apply so that the record is loaded from the file.How do I go about doing this via a form? I have a naming convention so I'm hoping that I can submit some mysql command...please help Quote Link to comment Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 You mean uploading files to mysql? Quote Link to comment Share on other sites More sharing options...
mATOK Posted August 15, 2006 Author Share Posted August 15, 2006 Perhaps, I don't know.I have an empty table with fields of type Medium txt. I just want to be able to populate these fields via a form.If I do it using the MySQL control center I create a txt file, name it and apply it. I'm just wondering how to do all this via a form and action script Quote Link to comment Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 Populate these fields with the contents of the "txt file"? I don't understand. Quote Link to comment Share on other sites More sharing options...
mATOK Posted August 15, 2006 Author Share Posted August 15, 2006 can I do a straight "UPDATE table SET lotzoftxt='$data'; If lotzoftxt is of type mediumtext? Or do I need to specify anything else? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 Yes, you can issue the statement you described -- just beware of quoting issues. 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.