Team Selection page SQL update error

I'm quite sure the syntax for update is correct like on my edit.php page however, when I try to update the selections table for a selected fixture from a drop down list form, it throws out this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1='', defender 2='', defender 3='', defender 4='', midfielder 1='', mid' at line 1

I hope that's not too vague but, it's the only complaint the server has and I've tried multiple things to sort it out like, changing the inverted commas, using an insert statement instead, etc. to no avail. Same error pops up only after I select players for a certain fixture and click the UPDATE button at the bottom of the form...

MySQL version 5.5.

Anyone else have/had an issue with an UPDATE function and knows how to sort it out?

The error means there is a typo somewhere. looking at it you should not have have a space in a column name. Else use a backtick as in `defender 3`

Ok I see. I'll try your suggestions out and report back here. Thanks.

MAc, I've got it working now. I tried your methods but, they didn't work so, I simply removed the spaces in the DB selections table itself and changed the coding accordingly. Works great now!

can anyone help me fix this code, i have an error which says "query was empty" when I update the selection_team table

$sql = mysql_query("UPDATE team SET GoalKeeper='$_POST[Goal_keeper]',Fullback='$_POST[Full_Back]',
wing='$_POST[Wing]', middlefield='$_POST[Middle_Field]', striker='$_POST[Striker]'
AND fixture_id=$_POST[fixture_id] WHERE selection_id=$_POST[selection_id] ";
mysql_query($sql) or die('not successfully'.mysql_error());

Please format your code.
Remove the mysql_query( from the first line:

$sql = "UPDATE team SET and so forth

Yoh...

Hi. Mac

Im having a problem with connecting my database, I registered on 000webhost.com, then I uploaded all my files on file manager in public folder, and also create a database. then i amend the connection part using the name of the database, username, password and host name the way it has been named. then I get an error which says:

Warning: mysql_connect() [function.mysql-connect]: Host '31.170.160.75' is not allowed to connect to this MySQL server in /home/a4546305/public_html/connect.php on line 7

Free Web Hosting
Host '31.170.160.75' is not allowed to connect to this MySQL server

Please help fix the error

What does this have to do with this topic??

I cannot help with such errors as I do not know what you have done/not done. Maybe it was just down for a while. No one else had this problem....?