php mysql操作语法错误_php中的mysql语法错误，输入phpmyadmin时工作正常

我试图用一个在for循环中递增的数组来查询我的数据库。出于某种原因，无论我做什么，这都不起作用，

我得到的错误：

"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 ')' at line 1"

当在PHPMyAdmin中查询数据库时，一切都很好，所以我假设for循环中的某些东西正在搞砸它。有任何想法吗？

我的代码： -

$submitclick=$_GET["submitclick"];

if($submitclick==1)

{

require('json.php');

$selec=$_GET["selec"];

$selec=str_replace("'","",$selec);

error_reporting(E_ALL);

mysql_connect("localhost", "seamus", "password") or

die("Could not connect: " . mysql_error());

mysql_select_db("seamus") or die("No such database");

$sql1 = sprintf("SELECT event FROM attends WHERE student = '%s'",$selec);

$result1 = mysql_query($sql1)

or die(mysql_error());

while ($row1 = mysql_fetch_array($result1))

{

$eve[] = $row1['event'];

}

for($f=0;$f

{

$sql = sprintf("SELECT event.id, teaches.staff, day, start, duration, room FROM event JOIN module ON (event.module=module.id) JOIN isin ON (event.id=isin.event) JOIN teaches ON (event.id=teaches.event) JOIN attends ON (event.id=attends.event) WHERE event.id = '%s')",$eve[$f]);

$result = mysql_query($sql)

or die(mysql_error());

$i=0;

while ($row = mysql_fetch_array($result))

{

$key =$row['day'].$row['start'];

$event[$key] = $row['id'];

$room[$row['id']] = $row['room'];

$lect[$row['id']] = $row['staff'];

$time[$i]= $row['duration'];

$i++;

}

}

$i=0;