parse error, unexpected T_STRING in
 

I'm trying to learn php and I'm trying to build a simple form that stores data. However, I'm getting this error message when I submit my form:

Parse error: parse error, unexpected T_STRING in /sites/yuma2/swaters210/home/public_html/music/music.php on line 7


you check out my form here: http://www.stevenwaters.net/music/index.html

 



<?

$artist=$_POST['artist'];

$song=$_POST['song'];

$album=$_POST['album'];

mysql_connect("localhost", "swaters210", "password") or die(mysql_error());

mysql_select_db("swaters210") or die(mysql_error());

CREATE TABLE data (artist VARCHAR(30), song VARCHAR(30), album VARCHAR(30));

mysql_query("INSERT INTO `data` VALUES ('$artist', '$song', '$album')");

Print "Your information has been successfully added to the database.";

?>

FYI: I do know I have to replace password with an actual password, which I have.

<form method="POST" action="music.php">

<label for="artist"><b>Artist Name:</b></label>

<input type="text" name="artist" value="" /><br />

<label for="song"><b>Song Title:</b></label>

<input type="text" name="song" value="" /><br />

<label for="album"><b>Album:</b></label>

<input type="text" name="album" value="" /><br />

<input type="submit" name="submitbutton" id="submitbutton" value="Submit" />

Can someone check it out for me? I would appreciate it. I was going to post in a similiar thread, but wasn't sure if anybody would see it.

Re: parse error, unexpected T_STRING in
 

What is exactly line 7 within your .php file?
It's just a syntax error, and can be worked out momentarily for you :)

Cheers.

Re: parse error, unexpected T_STRING in
 

What is this ?!?

CREATE TABLE data (artist VARCHAR(30), song VARCHAR(30), album VARCHAR(30));

- Mitko Kostov

Re: parse error, unexpected T_STRING in
 

yes that's the problem then! lol that code either shouldnt be there! it's not valid PHP, if its a valid mySQL function it will need wrapped in a mysql_query() statement :)

Welldone Mitko for spotting it ;)

Re: parse error, unexpected T_STRING in
 

How do you wrap it in a mysql_query() statement? I was just following this tutorial here:

http://php.about.com/od/phpbasics/ss/mysql_files_2.htm

Re: parse error, unexpected T_STRING in
 

the purpose of this, is just to check if the SQL table actually exists before you INSERT data into it. If you're sure that the table exists (that you've created it), then you won't need this, its just to stop noobies from doing insert's into a table that doesnt' exist :)

Re: parse error, unexpected T_STRING in
 

I see. I'm lacking knowledge in the basics. Thanks for all your help.

-Newbie

Re: parse error, unexpected T_STRING in
 

Any time ;)