Simple text pulling from MySQL

[drawde]

Hi guys,

I'm a complete newbie and desperatly need to do a very simple query from a MySQL database using PHP. Here's the situation:

I have a .php page that has a blank table which needs to be filled in with a block of text stored in the database.

Question1. How do I pull that block of text from the database and print them dynamically on the page?

Question2. How do I create a page (interface) which contains a form such that the text field of the form shows that block of text currently stored in the database? This is to allow users to change the text and then post and store it back in the database (replacing the previous contents).

Thanks heaps guys. I am really banking on this forum to help me out of my misery... Detailed instructions would be much appreciated.

 

[drawde]

Oh, also, is there a limit to the length of text that can be stored in MySQL? Is it possible to store a couple of hundred of words in that single table?

Thanks...

 

[drawde]

I've managed to answered those above now...

But I would like to know how to load a data file into the table I've created? I'm accessing my database using a client software that resides on the same machine as the MySQL server, but my home directory is at a different location and I do not have the privilege to write to the directories where MySQL is.

Can someone please tell me where should I place my data files e.g. data.txt and should I use the LOCAL option when loading the file from my directories? What should the syntax be like?

Thanks!