Problems Inserting imploded variables to mysql

[Wolfe]

Hey, I'm having trouble getting this query to go through and I don't know why it won't.

$field_array = array_keys($fields_form);
		$fields=implode(",",$field_array);
		$values=implode('","',$fields_form);
		$query = 'INSERT INTO Table ($fields) VALUES (\"$values\")';
		$result = mysql_query($query) or die ("Couldnt execute blasted query.");

Any help with this would be greatly appreciated, Thanks.

[Weedpacket]

Some suggestions are given here. Note, too, that MySQL's own error messages are likely to be more informative than a generic one of your own.

[johanafm]

And apart from looking at the actual database error message which would tell you where you are not following the SQL syntax, you should also make the input data safe for use with the databse. In your case this doesn't only apply to the data being inserted in the database, but also to the field identifiers since you seem to allow users to provide these identifiers themselves.