Help!!!

[mart]

I have tested the following on my home server which has mysql 5.0 installed , and it works well:

$userid ="F0000100";

$query = "INSERT INTO players (userid) VALUE ('$userid')";
mysql_query($query,$link)or die(mysql_error());

On another server which has mysql 4.0.22 installed it gives me the following error message:

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 '(players) userid VALUE ('F0000100')' at line 1

I've tried everything that I could think. What I am doing wrong?

[mrhappiness]

Originally posted by mart
$query = "INSERT INTO players (userid) VALUE ('$userid')";
[...]
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 '(players) userid VALUE ('F0000100')' at line 1

the error message doesn't match the sql you posted

change your mysql_query to

 mysql_query($query,$link)or die(mysql_error().'<hr />'.$query.'<hr />');

and post the result please

[mart]

this is the error I get with the code you added, mrhappy:

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 'VALUE ('F0000100')' at line 1

INSERT INTO players (userid) VALUE ('F0000100')

[mrhappiness]

why didn't you simply the the syntax at http://dev.mysql.com/doc/mysql/en/INSERT.html? 😕

VALUE is wrong
VALUES is right

[mart]

Thank you mrhappy.

I did check, but completely missed it.🙂