这句话出错,请教错在何处

这句话出错,,请问错在何处

$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

这句话出错,请教错在何处

相关文章:

你感兴趣的文章:

标签云: