[RESOLVED] Cannot get create table script to work

[h3luna]

Hello im not all that new in php scripting, bu i just started php + mysql so please bare with me.

I have the basic script:

<?php
$con = mysql_connect("localhost","user","password");
if(!$con)
{
die('Could not connect: '.mysql_error());
}
else
{
echo "You have connected to database";
}
//create table for peeps
mysql_select_db("database name", $con);
$sql = "CREATE TABLE Persons
(
FirstName varchar(15),
LastName varchar(15),
Age int,
UserName varchar(15),
Password(15),
)";

mysql_query($sql,$con);

mysql_close($con);
?>

however i always get the error message

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&lt;?PHP
$con = mysql_connect("localhost","user"' at line 1

im not quite sure what i am doing wrong, ofcourse the username, password, database name ans host has been replaced in here, i have confirmed that i am able to connect. its getting me pretty upset because i know that its a simple script and i cant get it to work.:mad: please assist!

[NogDog]

How/where are you running this script? From the error message, it sounds like it's choking on a <?php tag, such as if you are trying to load your PHP script directly from the mysql command line or something?

[h3luna]

i first tried to run it by uploading it to the server, but the database was not created, i was later advice to run in in the query on phpmyadmin, and thats where i got this error message.

[dagon]

the phpmyadmin sql tab is expecting sql, not php. either past this in:

CREATE TABLE Persons
(
FirstName varchar(15),
LastName varchar(15),
Age int,
UserName varchar(15),
Password varchar(15)
)

or go to the operations tag, the use its interface for creating tables

[h3luna]

Thanks, that clarified a lot for me! just trying to figure out now, why the script was not working as php file on the server outside of phpmyadmin. any ideas?

[dagon]

notice i edited the actual query above.

[h3luna]

yea, i saw my error with the missing varchar for password. thank you!