Welcome to WebmasterWorld Guest from 22.214.171.124
$result = mysql_query("SELECT * FROM character where uid = '1'", $link) or die ("query 1: " . mysql_error());
$row = mysql_fetch_array($result);
Im getting this error
query 1: 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 'character where uid = '1'' at line 1
$result = mysql_query("SELECT * FROM character WHERE uid=1", $link) or die ("query 1: " . mysql_error());
I am relative newb to PHP and MySQL so take this with grain of salt….
The words in the following table are explicitly reserved in MySQL 5.0. At some point, you might update to a higher version, so it's a good idea to have a look at future reserved words, too. You can find these in the manuals that cover higher versions of MySQL. Most of the words in the table are forbidden by standard SQL as column or table names (for example, GROUP). A few are reserved because MySQL needs them and (currently) uses a yacc parser. A reserved word can be used as an identifier if you quote it.
Among the words is indeed 'character'.