while($i <= $no){
    $leave = strtotime('+'.$i.' day', ($_REQUEST['leave']));
    $start = strtotime('+'.$i.' day', ($_REQUEST['start']));

    $result = mysql_query("INSERT INTO jobs VALUES ('',$_REQUEST[company],'$_REQUEST[address]','$_REQUEST[suburb]',FROM_UNIXTIME($leave),FROM_UNIXTIME($start),NULL,'$_REQUEST[vehicle]','$_REQUEST[special_eq]','$_REQUEST[notes]',0);");

    if(!$result)
    {
        $commit = "rollback";
        $querylog .= "error in query at line 108: ". $result . "/" . mysql_error() . "";
    };

    $id = mysql_insert_id();


    $result = mysql_query("UPDATE jobs SET recursive_index=$main_job_id WHERE id=$id;");

    if(!$result)
    {
        $commit = "rollback";
        $querylog .= " ". $result . "/" . mysql_error() . "";
    };

    $tcs = explode(',',$_REQUEST[tc_id]);
    $j = count($tcs) - 1;
    $k = 1;

    while($k <= $j){
        $query = mysql_query("SELECT id FROM jobs_tc WHERE ((tc_id = $tcs[$k]) AND ((start_time <= (DATE_ADD(FROM_UNIXTIME($start),INTERVAL 7 HOUR))) AND (DATE_ADD(start_time,INTERVAL 7 HOUR) >= (FROM_UNIXTIME($leave)))));");
        if(mysql_num_rows($query) != 0){
            $query = mysql_query("SELECT firstname, surname FROM tc WHERE id = $tcs[$k];");
            $row = mysql_fetch_assoc($query);
            $date = date('j/m/y', $leave);
            $tc_log .= ";".$row[firstname]." ".$row[surname].".".$date."";
        } else {
            $result = mysql_query("INSERT INTO jobs_tc VALUES ('',$id,$tcs[$k],FROM_UNIXTIME($leave),FROM_UNIXTIME($start),NULL,0);");

            if(!$result)
            {
                $commit = "rollback";
                $querylog .= "error in query at line 130: ". $result . "/" . mysql_error() . "";
            };
        };
        $k++;
    };


$i++;
};