Fatal error: Maximum execution time of 60 seconds exceeded in

<?php
	  @session_start();
			$username=$_SESSION['username'];
	        $password=$_SESSION['password']; 
		if(!isset($_SESSION['username']) and !isset($_SESSION['password'])){
			header ("Location: L041n.php") ;
			exit();
		}   ?>
        <?php date_default_timezone_set('Asia/Bangkok');?>
<?php
    //¡Ó˹´ª×èÍ host/username/password/databasename ¡è͹
    mysql_connect('localhost','root','root') or die(mysql_error());
    mysql_select_db('kuasc') or die(mysql_error());

    //create test data
   /*  $r = mysql_query("SHOW TABLES LIKE 'order_test'");
    if (mysql_num_rows($r) == 0) {
        mysql_query(
        'CREATE TABLE `order_test` ('.
          '`uid` int NOT NULL AUTO_INCREMENT,'.
          '`id` varchar(10) NOT NULL,'.
          'PRIMARY KEY (`id`), UNIQUE KEY(`uid`)'.
        ')'
        ) or die(mysql_error());
        echo 'create table order_test successfully.<br>';
    } */
@session_start();
			$username=$_SESSION['username'];
	        //$password=$_SESSION['password']; 
   if ($username=='sahachon') {
   $r_onn = ('AL1'); 
   $c_yearn = date('Y');
    $rn = mysql_query("SELECT id FROM `test` WHERE uid=(SELECT MAX(uid) FROM `test` WHERE id LIKE '$c_yearn%')");
    $n_numbern = mysql_num_rows($rn) ? substr(mysql_result($rn,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_yearn.$r_onn.sprintf("%05d", ++$n_numbern);
        $sqln = "INSERT INTO test(id) VALUES('$n_ida')";
        mysql_query($sqln);
    }
    while (mysql_errno() == 1062); } else if ($username=='noppadon') {
   $r_onn = ('AL2'); 
   $c_yearn = date('Y');
    $rn = mysql_query("SELECT id FROM `test2` WHERE uid=(SELECT MAX(uid) FROM `test2` WHERE id LIKE '$c_yearn%')");
    $n_numbern = mysql_num_rows($rn) ? substr(mysql_result($rn,0),6) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_yearn.$r_onn.sprintf("%05d", ++$n_numbern);
        $sql = "INSERT INTO test2(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); } else if ($username=='rithai') {
   $r_onn = ('AL3'); 
   $c_yearn = date('Y');
    $rn = mysql_query("SELECT id FROM `test3` WHERE uid=(SELECT MAX(uid) FROM `test3` WHERE id LIKE '$c_yearn%')");
    $n_numbern = mysql_num_rows($rn) ? substr(mysql_result($rn,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_yearn.$r_onn.sprintf("%05d", ++$n_numbern);
        $sqln = "INSERT INTO test3(id) VALUES('$n_ida')";
        mysql_query($sqln);
    }
    while (mysql_errno() == 20000); }  else if ($username=='sira') {
   $r_on = ('AL4'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test4` WHERE uid=(SELECT MAX(uid) FROM `test4` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test4(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); } else if ($username=='panormas') {
   $r_on = ('AL5'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test5` WHERE uid=(SELECT MAX(uid) FROM `test5` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test5(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); }  else if ($username=='lakkana') {
   $r_on = ('AL6'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test6` WHERE uid=(SELECT MAX(uid) FROM `test6` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test6(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); }  else if ($username=='noppon' or $username=='apicha') {
   $r_on = ('AL7'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test7` WHERE uid=(SELECT MAX(uid) FROM `test7` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test7(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); }  else if ($username=='wipawadee') {
   $r_on = ('AL8'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test8` WHERE uid=(SELECT MAX(uid) FROM `test8` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test8(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); }  else if ($username=='tipat' or $username=='kanin') {
   $r_on = ('AL9'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test9` WHERE uid=(SELECT MAX(uid) FROM `test9` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test9(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); }  else if ($username=='umnad' or $username=='kajonsak' or $username=='itsarapong') {
   $r_on = ('AL10'); 
   $c_year = date('Y');
    $r = mysql_query("SELECT id FROM `test10` WHERE uid=(SELECT MAX(uid) FROM `test10` WHERE id LIKE '$c_year%')");
    $n_number = mysql_num_rows($r) ? substr(mysql_result($r,0),5) : 0;

    //run query insert ä»àÃ×èÍÂæ ¨¹¡ÇèÒ¨ÐäÁè error 1062 (error key «éÓ)
    do {
        $n_ida = $c_year.$r_on.sprintf("%05d", ++$n_number);
        $sql = "INSERT INTO test10(id) VALUES('$n_ida')";
        mysql_query($sql);
    }
    while (mysql_errno() == 20000); }  
    //echo $sql;      
?>