用两个值计算行数mysql（PHP错误）[关闭]

Question

I have the following code, but for some reason I am getting an unexpected T_Variable. I can't seem to figure out where I am getting the error at. Any assistance will be greatly appreciated. Thanks

<? php 
$status = mysql_query('SELECT count(*) FROM AHG WHERE `Survey Tech Initials` = 'Jeff' AND   completed = 'yes');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
?>

Answer 1

See below

<? php 
$status = mysql_query("SELECT count(*) FROM AHG WHERE `Survey Tech Initials` = 'Jeff' AND completed = 'yes'");
if (!$result) {
die('Invalid query: ' . mysql_error());
}
?>