[SOLVED] PHP MASTER, anyone? - myannoyingsql

[TheFilmGod]

// now we insert it into the database
$insert = "INSERT INTO homecoming (name, brunch, dance, game)
VALUES ('$name', '$brunch', '$dance', '$game')";
mysql_query($insert) or die("Error: ". mysql_error(). " with query ". $insert);

 

I know there was a similar topic to this recently but I didn't want to post my code there. I don't get the problem. Please help! I'm a newbie!! Super newbie!  :'(

[lightningstrike]

Are you sure you used mysql_select_db() to select the database you are using, prior to making your query.

 

http://www.php.net/mysql_select_db

 

If so it's possible you may have unescaped quotes in the variables (check by printing them) if so, escape them with mysql_real_escape_string();

 

http://www.php.net/mysql_real_escape_string

[tibberous]

... if so, escape them with mysql_real_escape_string(); ...

 

And if not

 

Whats the output? Error message?

[TheFilmGod]

I got it to work. I didn't declare the database.