php mysql 超时 设置_PHP MySQL的小查询超时，必须将限制设置为10

当为相对较小的查询调用mysql_query()时，我得到了PHP超时错误，所以我必须将限制设置为10。

Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\htdocs\data.php on line 19我已经从代码中删除了循环，代码似乎挂在了mysql_query()函数中。

mysql_connect("192.168.50.250",$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT T.Tag as 'Device', y.alarmdesc as 'AlarmType', a.Active, a.Cleared FROM gencore.gc_alarms a JOIN ist.Tree T ON(T.DeviceId = a.DeviceId) JOIN GenCore.gc_alarmtypes y ON (a.alarmType = y.aid) LIMIT 10";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

Device	AlarmType

$i=0;

while ($i < $num)

{

$f1=mysql_result($result,$i,"Device");

$f2=mysql_result($result,$i,"AlarmType");

?>

<?php echo $f1; ?><?php echo $f2; ?>

$i++;

}

?>