日期:2014-05-16  浏览次数:20836 次

这句话出错,,请问错在何处
$sql="select per.id,pay.eid,mec.eid,rec.eid,* from employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec where per.id=pay.eid and per.id=med.eid and per.id=rec.eid and per.id=".$_GET['cID'];




提示
1064 - 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 '* from employee_personal_information per,employee_payroll pay,employee_medical_i' at line 1

select per.id,pay.eid,mec.eid,rec.eid,* from employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec where per.id=pay.eid and per.id=med.eid and per.id=rec.eid and per.id=2

[TEP STOP]



------解决方案--------------------
SELECT *,per.id,pay.eid,mec.eid,rec.eid FROM employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec
 WHERE per.id=pay.eid AND per.id=med.eid AND per.id=rec.eid AND per.id=2