[mySQL/PHP] mysql_query error.. with table name.?

mysql_select_db($dbname); $table = 'menu-pizza'; $sql = "SELECT * FROM $table"; $result = mysql_query($sql); 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 '-pizza' at line 1 Must I have to... show more mysql_select_db($dbname);
$table = 'menu-pizza';
$sql = "SELECT * FROM $table";
$result = mysql_query($sql);

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

Must I have to rename my table to exclude the minus sign? or is there a way to include the minus sign without it giving me problems..?

Thanks in advance!
Update: If needed:
mySQL version
5.1.47-community-log
4 answers 4