Jump to content


Photo

mediumtxt


  • Please log in to reply
5 replies to this topic

#1 mATOK

mATOK
  • Members
  • PipPipPip
  • Advanced Member
  • 84 posts
  • LocationToronto, Ontario

Posted 15 August 2006 - 12:47 PM

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 
"Not everything that counts can be counted, and not everything that can be counted counts."

W3 Web Tutorials | Check Your html | CSS layout techniques | ALA | Zen Garden | CSS Links

Navs with flavor | CSS Playground | CSS boxes

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 August 2006 - 01:58 PM

You mean uploading files to mysql?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 mATOK

mATOK
  • Members
  • PipPipPip
  • Advanced Member
  • 84 posts
  • LocationToronto, Ontario

Posted 15 August 2006 - 03:30 PM

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
"Not everything that counts can be counted, and not everything that can be counted counts."

W3 Web Tutorials | Check Your html | CSS layout techniques | ALA | Zen Garden | CSS Links

Navs with flavor | CSS Playground | CSS boxes

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 August 2006 - 04:17 PM

Populate these fields with the contents of the "txt file"?  I don't understand.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 mATOK

mATOK
  • Members
  • PipPipPip
  • Advanced Member
  • 84 posts
  • LocationToronto, Ontario

Posted 15 August 2006 - 04:25 PM

can I do a straight "UPDATE table SET lotzoftxt='$data';

If lotzoftxt is of type mediumtext? Or do I need to specify anything else?
"Not everything that counts can be counted, and not everything that can be counted counts."

W3 Web Tutorials | Check Your html | CSS layout techniques | ALA | Zen Garden | CSS Links

Navs with flavor | CSS Playground | CSS boxes

#6 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 August 2006 - 05:33 PM

Yes, you can issue the statement you described -- just beware of quoting issues.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users