parse error on create

adavis

I'm trying to create a table and keep getting a parse error:

Parse error: parse error in
/usr/home/website/public_html/htdocs/buildVerse.php on line 33

33 CREATE TABLE bibleverse (
34 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
35 verse TEXT DEFAULT NULL,
36 chapter VARCHAR(55) DEFAULT NULL
37 );

Can anyone see anything wrong with this statement? I've looked at it and changed it around until I'm cross-eyed. I apparently get past my link statement which is in line 30, so I'm connecting to the database ok.

Thanks,
Alisa

jburfield

It would help if you posted the actual code you have in your page...

I'm assuming you have something set up where $query = 'your create statement here' and then you run that inside of mysql_query($query, $link_to_db) correct?

Most likely you have some sort of error in that statement somewhere...perhaps you need to escape a character?

-- Jason

adavis

I've copied my code at the bottom. If I comment out the CREATE statement and the INSERT statements and the part where I try to read the table and print out the results, and just run it with the $link = mysql_connect ($hostname, $username, $password); statement, I get:

start
end

as my output with no errors, so to me it looks like it connecting to the database okay, but the CREATE statment is not working.

Here's my code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Database connect</title>
</head>
<body>
 start
<?php
// fill the information to variables:
$hostname = "localhost";
$username = "myusername";
$password = "mypassword";
$dbname = "mydatebasename";

// connect to the database host, you can use "localhost" instead of $hostname, if the mysql server is the same machine as your web-server:
$link = mysql_connect ($hostname, $username, $password);

// create table
CREATE TABLE bibleverse (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
verse TEXT DEFAULT NULL,
chapter VARCHAR(55) DEFAULT NULL
)

// build table
INSERT INTO verse VALUES (1,'Let us not give up meeting together, as some are in the habit of doing, but let us encourage one another - and all the more as you see the Day approaching.','Hebrews 10:25');
INSERT INTO verse VALUES (2,'My mouth will speak words of wisdom; the utterance from my heart will give understanding.','Psalms 49:3');
INSERT INTO verse VALUES (3,'In the house of the wise are stores of choice food and oil, but the foolish man devours all he has.','Proverbs 21:20');
INSERT INTO verse VALUES (4,'Woe to the rebellious children, says the Lord, Who take counsel, but not of Me, And who devis plans, but not of My spirit, That they may add to sin.','Isaiah 30:1');
INSERT INTO verse VALUES (5,'Train up a child in the way he should go, and when he is old, he will not depart from it. The rich rule over the poor and the Borrower is servant to the Lender.','Proverbs 22:6-7');

// query the database: select all the records in table "verse":
$query = mysql_db_query($dbname,"select * from verse;") or die("Query failed");

// retrieve the results: this retrieves the first record:
$result = mysql_fetch_object ($query);

while ($row = mysql_fetch_row($result)) {
if (mysql_errno()) {
die(" ".mysql_errno().": ".mysql_error()." ");
}
foreach ($row as $column) {
echo " $column";
}
echo " ";
}

// close the database connection
mysql_close ($link);
?>
 end
</body>
</html>