Am I blind?

[slighltywhacked]

k..im going insane..

using a simple insert statement..nuthing fancy

$result = mysql_query("INSERT INTO users VALUES ($uid, '$name', '$phone', '$address', '$email', '$website')")
            or die("line 15, data was not inserted ".mysql_error()); 

looks fine..right??

it produces this error

You have an error in your SQL syntax near ')' at line 1 

Am i not seeing the error?? all the quotes are there... al opening brackets have closed onces..commas are in right place...
IM GOIN INSANE
AAAAHHHHHHHHHHH....


thanx

[freddydoesphp]

Is it possible one of your variables has a un escaped character in it. Like a quote. I would suggest printing the sql statement to the screen and see what it turns up.

$sql = "INSERT INTO users VALUES ($uid, '$name', '$phone', '$address', '$email', '$website')";
print $sql;
$result = mysql_query($sql)
            or die("line 15, data was not inserted ".mysql_error()); 

[slighltywhacked]

already tried that
all the variables are be putting through and dont have any "special" characters

[Mike Henderson]

Shouldn't this:

VALUES ($uid, '$name' 

be like this:

VALUES ('$uid', '$name' 

All I can see is that you forgot the ' and ' around $uid

[petesmc]

Remove the die section and see if it works..

[freddydoesphp]

Mike if $uid only contains numbers then you don't need to use quotes around it.