parse error, unexpected T_STRING in

[swaters86]

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="" />
<label for="song"><b>Song Title:</b></label>
<input type="text" name="song" value="" />
<label for="album"><b>Album:</b></label>
<input type="text" name="album" value="" />
<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.

[dr4g]

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

Cheers.

[MitkOK]

What is this ?!?

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

- Mitko Kostov

[dr4g]

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 ;)

[swaters86]

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

[dr4g]

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 :)

[swaters86]

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

-Newbie

[dr4g]

Any time ;)