I'm learning php and Mysql , i'm copy script for teaching from project professional book whatever when running this script :
<?php $host="localhost"; $dbusername="root"; $dbpassword="root"; $database="books"; $x=mysql_connect("localhost","root","root") or die(mysql_error()); $x2=mysql_select_db($books); if (empty ($category)) { $category=1; } $childval=$category; $query = "Select categoryid,name from categroy where categoryid=\"".$childval."\""; $result=mysql_query($query); if ([email protected]_fetch_array($result)) { $catid[1]=$row["categoryid"]; $catname[1]=$row["name"]; } while (!($childval==0)) { $query="select parentcategoryid from category where categoryid=\"".$childval."\""; $result=mysql_query($query); if ([email protected]_fetch_array($result)) { $childval=$row["parentcategoryid"]; $query="select categoryid,name from category where categoryid=\"".$childval."\""; $result=mysql_query($query); if($row=mysql_fetch_array($result)) { $catid[]=$row["categoryid"]; $catname[]=$row["name"]; } } } for ($i=count($catname);$i>0;$i) { echo "<A href=visitor.php?category=".$catid[$i].">".$catname[$i]."</a>>"; } ?>
The problem appears :Fatal error: Maximum execution time of 180 seconds exceeded in C:\AppServ\www\project.php on line 32
Should be the cause.
Hello,
Increase your php.ini max_execution_time from 180 to 300 seconds and restart your Appserv. See if that helps