这句话出错,,请问错在何处
$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