while($row1=mysql_fetch_array($guru)){ $view=mysql_query("*SELECT* FROM tbl_jadwal jadwal, setup_kelas kelas, setup_pelajaran pelajaran($view)){$view=mysql_query("*SELECT* FROM tbl_jadwal jadwal, set
我讨厌在互联网上要求人们对一个相当简单的MySQL视图进行语法检查,但是我找不出语法出了什么问题。我已经尝试了我能想到的所有方法,但我仍然得到1064错误,没有任何特定的错误消息。CREATE VIEW viewClientList AS ( tblClient.strName AS 'Name', count(*)
("SELECT jobs.*, files.* FROM jobs INNER JOIN files WHERE files.jobid = jobs.id") or die(mysql_error(WHERE id=$id") or die(mysql_error()); //delete from just jobs table
$result = mysql_query("DELETEalso delete file records from files t