Parse error: syntax error, unexpected T_STRING in /home/syren/public_html/createtable

syren

I am getting the error "Parse error: syntax error, unexpected T_STRING in /home/syren/public_html/createtable.php on line 16"
Line 16 seems to be

print ("The query was executed");

Does anyone have any idea what I am missing? If i need to paste the code a different way just let me know.

<HTML>
<HEAD>
<TITLE></Title>
<body>
<?PHP

$Host="localhost";
$User="syren";
$Password="*****";
$DBName="helpdesk";
$TableName="Downtime";

$link = mysql_connect ($host, $User, $Password);
$Query ="CREATE table $TableName (id INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, Ticket varchar(6), System VarChar(20), Verbiage VarChar(85), Analyst VarChar(20), Worker VarChar(20));
if (mysql_db_query ($DBName, $Query, $Link)) {
print ("The query was executed");
} else {
print ("The query could not be executed<br>\n");
}
mysql_close ($Link);
?>

</body>
</html>

jeepin81

You're missing the closing quote on the end of your query.

<?PHP

$Host="localhost";
$User="syren";
$Password="*****";
$DBName="helpdesk";
$TableName="Downtime";

$link = mysql_connect ($host, $User, $Password);
$Query ="CREATE table $TableName (id INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, Ticket varchar(6), System VarChar(20), Verbiage VarChar(85), Analyst VarChar(20), Worker VarChar(20))";

if (mysql_db_query ($DBName, $Query, $Link)) {
print ("The query was executed");
} 
else {
print ("The query could not be executed<br>\n");
}
mysql_close ($Link);
?>

Also, when you get those errors more times than not it is the line above what is listed. For what you are trying to do you could always use phpMyAdmin.

Hope this helps.
j

syren

O yes, I see it. Thanks