mysql error help - You have an error in your SQL syntax...

[MDanz]

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 '-course WHERE GRADE BETWEEN 0 AND 9' at line 1

 

class Grade {


public function results($grade)
	{

	$beginning = $grade-9;


$query = mysql_query("SELECT * FROM student-course WHERE GRADE BETWEEN $beginning AND $grade") or die(mysql_error());

			while($row = mysql_fetch_assoc($query)) {

			$sid = $row['SID'];
			$cid = $row['CID'];

			echo "<li>$sid-$cid</li>";

			}
	}
}

?>

 

why am i getting this error?

[PFMaBiSmAd]

You shouldn't use special characters in table names. The - is a special character. Only the set of alphanumeric characters from the current character set, “_”, and “$” are not special.

[MDanz]

can't i put backticks around the table name or apostrophes?