[Seanmcn]

$query = "SELECT * FROM char_stats WHERE id=". $userid;
$result = mysql_query($query) or die(mysql_error());

Getting the 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 '' at line 1

Would usually fiddle with this manually, but I dont understand why it can work in one file and then not in another..

This post has been edited by Seanmcn: 18 April 2009 - 11:08 AM

[BGDeveloper]

Mmmmm

$query = mysql_query("SELECT * FROM `char_stats` WHERE `id` = {$userid}") or die(mysql_error());

try this.

[SpaceMan]

my thots also, reserved name maybe.
but you say works on another page...

may try
if(is_numeric($userid)){
run query....
}

This post has been edited by SpaceMan: 18 April 2009 - 08:56 AM

[BMR777]

Maybe:

$query = "SELECT * FROM char_stats WHERE id='$userid'";

OR

$query = "SELECT * FROM char_stats WHERE id='".$userid."'";

Both should work fine.

[SpaceMan]

error says at '', so $id was empty, he sent me a note saying it is fixed.