Simple error which is weird..>!

rh_arris

hi!

a simple error it looks here ... i just cant figure out what it is! i have the following code:

		  <?
		  include ('restrict/connect.php');


// The Result will return amount of rows, and the rows are defined by MYSQL rows.
$query = "SELECT * FROM restrict ";
#echo "$query";
#exit();
$result=mysql_query($query); 
if (!$result)  { 
exit('<p>Error performing query: ' . mysql_error() . '</p>'); 
}
$num=mysql_numrows($result);
$i=0;
while ($i < $num) { #do something


$username=mysql_result($result,$i,"username");

// increase I once again. 

$i++ ;
} // close brackets


?>

which throws the following error:

Error performing query: 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 'restrict' at line 1

i can't see how!

thanks for all your help

bradgrafelman

"RESTRICT" is a MySQL reserved word, thus MySQL doesn't realize you're talking about a table called 'restrict'.

To specifically denote a table, column, or database, surround the name in backticks (), e.g. [b]SELECT * FROMrestrict`[/b] .