php - mysql_fetch_assoc() 中的参数不想显示；

Question

我不明白为什么 echo 不显示值。在phpmyadmin sow查询中查询返回值就可以了。请帮忙

$query="SELECT `doctor_name` , `doctor_secondname` 
FROM `doctors`
INNER JOIN `patients` ON `patients`.doctor_id = `doctors`.doctor_id 
WHERE `patients`.patient_id = '{.$patient_id.}'" ;

$result = mysql_query($query) or die(mysql_error());

print_r($row);
if(mysql_num_rows($result) > 0) {
$row    = mysql_fetch_assoc($result);
echo "Your doctor is :";
echo $row['doctor_name'];
echo $row['doctor_secondname'];
   }

Answer 1

试试这个:

$query="SELECT doctor_name , doctor_secondname 
FROM doctors
INNER JOIN patients ON patients.doctor_id = doctors.doctor_id 
WHERE patients.patient_id = '".$patient_id."'" ;