Since you do not even have the MySQL database yet ...
You need to go into your webhost and create a MySQL database.
Give it a username, password, and database name and enter those
into the script below. Follow your webhost configuration on the
name of the MySQL host.
This script creates the table you'll need.
Upload to your webhost and run it after you enter-in the account data:
PHP Code:
<?php
// Create the table and columns
// You should have already created the MySQL account
// with a database named "MyText".
// The name of your database goes here.
$dbname = 'MyText';
// Enter in your host, username and password here.
$link = mysql_connect("host","username","password") or die("Couldn't make connection.");
// Select the database
$db = mysql_select_db($dbname, $link) or die("Couldn't select database");
// This creates the table called "LinesOfText".
// The actual line of text (max of 255 characters),
// A timestamp ... you might want to use that later on,
// The submitters IP ... in case you want to use that,
// and an enable, if you later decide to "hide" or "enable" lines.
mysql_query("CREATE TABLE LinesOfText
(
TextID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(TextID),
TextLine varchar(255),
TimeStamp varchar(12),
UserIP varchar(20),
TextEnable varchar(3)
)") or die(mysql_error()); ;
echo "table created";
?>
Before you post, read our: 
