What is wrong???

[Wayetender]

Im trying to insert some data into my MySQL database. This isnt my first query, and I dont know what's wrong.
When I execute the query it says there is an error. heres my query:

$query = "insert into fgames
(game,publisher,release,platforms,sound,gameplay,graphics,unique,overall,review) values
('$game', '$publisher', '$release', '$platforms', '$sound', '$gameplay', '$graphics', '$unique', '$overall', '$review')"
;
mysql_query($query) or
die(mysql_error());

[cgraz]

What's the error?

The only thing I can think of is after fgames, when you specify the fields you will be inputting, there's no space between field names, but when you specify the values, you have a space between variables. Try

$query = "INSERT INTO fgames (game, publisher, release, platforms, sound, gameplay, graphics, unique, overall, review) VALUES ('$game', '$publisher', '$release', '$platforms', '$sound', '$gameplay', '$graphics', '$unique', '$overall', '$review')"; 
mysql_query($query) or die(mysql_error());

Or it may be that you mispelled one of the field names or one of the variables doesn't have a value assigned to it (both of which have happened to me)

Cgraz

[nemonoman]

change the error routine to

die(mysql_error()."<BR>$query");

and show us both the error number and the query as parsed by MySQL so we can help you more...

[surfer]

The problem may have to do with the data type of fields in the database. Are sure all the fields are text (string) ?