$endt =array(0 => "value");
 
elseif (!$count=0)
{
	while ($e_row = mysql_fetch_array($result))
	{
		$status = 'busy';
		// print the list into a table
		echo "<tr>";
		echo "<td>" . $e_row['fName'] . $e_row['lName'] . "</td>";
		echo "<td>" . $e_row['event_date'] . "</td>";
		echo "<td>" . $e_row['timeStart'] . "</td>";
		echo "<td>" . $e_row['agenda'] . "</td>";
		echo "<td>" . $status ."</td>";
 
		// $_SESSION array to accept 'event' emp_no & timeEnd
		//global $endt;
		//$endt=array($e_row['emp_no'] => $e_row['timeEnd']);
		$_SESSION['$endt']= array($e_row['emp_no'] => $e_row['timeEnd']);
	}
}

	// $_SESSION array to accept 'event' emp_no & timeEnd
		global $endt;
		$endt=array($e_row['emp_no'] => $e_row['timeEnd']);
		//$_SESSION['$endt']= array($e_row['emp_no'] => $e_row['timeEnd']);
		$_SESSION['$endt']= $endt;

function max_time()
 	{
 		// find out the highest figure in the array for the timeEnd, then add 100 for the next hour
 		//$_SESSION['$endt']= array($e_row['emp_no'] => $e_row['timeEnd']);
 		//foreach ($_SESSION['$endt'] as $key => $val) 
 		FOREACH($_SESSION['$endt'] as $key => $val)
 		{
 			if ($val == max($_SESSION['$endt']))
 			{
 				$_SESSION['my_key'] = $key;
 			}
 		}
 
 		add_time();
 	}
 
 	function add_time()
 	{
 		// increase the time to 1 hour forward
 		$_SESSION['my_key'] = $_SESSION['my_key'] + 100;
 
 		if ($_SESSION['my_key'] > 1700)
 		{
 			// discard scan plus writing record - pass control to abandon
 
 		}elseif ($_SESSION['my_key']<= 1700)
 		{
 			// do the new scan
 			scan();
 		}	
 	}

<?php
session_start(); 
// This prg automatically fixes a meeting after a scan for free slots
 //get the list from //$_SESSION['check_array'] for the emp_no's
 
 
 class Mfix{
 
 	function db()
 	{
 		$met = mysql_connect("","","");
   		if (!$met)
   		{
       		die('Could not connect: ' . mysql_error());
    	}
    	mysql_select_db("", $met);
 
 
 	}
 
 	function max_time()
 	{
 		// find out the highest figure in the array for the timeEnd, then add 100 for the next hour
 		//$_SESSION['$endt']= array($e_row['emp_no'] => $e_row['timeEnd']);
 		//foreach ($_SESSION['$endt'] as $key => $val) 
 		FOREACH($_SESSION['$endt'] as $key => $val)
 		{
 			if ($val == max($_SESSION['$endt']))
 			{
 				$_SESSION['my_key'] = $key;
 			}
 		}
 
 		add_time();
 	}
 
 	function add_time()
 	{
 		// increase the time to 1 hour forward
 		$_SESSION['my_key'] = $_SESSION['my_key'] + 100;
 
 		if ($_SESSION['my_key'] > 1700)
 		{
 			// discard scan plus writing record - pass control to abandon
 
 
 
 		}elseif ($_SESSION['my_key']<= 1700)
 		{
 
 
 			// do the new scan
 			scan();
 		}
 
 
 	}
 
 	function scan()
 	{
 		// connect to db
 		db();
 
 
 		//accept variables
 		FOREACH ($_SESSION['check_array'] as $check_array)
		{
		  $e_date = $_SESSION['meet_date']; 
		  $s_time = $_SESSION['my_key'];  // new value for timeEnd
		  //$emp_no = $check_array; 
 
		 /**
  		  * query the db
    	*/
 		 $sql = 'SELECT staff.emp_no, staff.fName, staff.lName, event.event_date, event.timeStart, event.timeEnd, event			.emp_no, event.agenda FROM `staff`, `event` WHERE staff.emp_no = event.emp_no AND event.emp_no = "'					   .$check_array.'" AND event.event_date = "'.$e_date.'" AND event.timeStart = "'.$s_time.'"';
 
		 $result = mysql_query($sql) or die(mysql_error());
 
		 // check for num_row_count if > 0 means trouble
 		$crazy=mysql_num_rows($result);
 
 		if ($crazy==0)
 		{ // insert record into event
 			write_meet();
 		}elseif($crazy>0)
 		{
 			// check value of $_SESSION['my_key']
 			if ($_SESSION['my_key'] >= 1700)
 			{
 				// end of the road - report can't continue with auto fix unless date is changed
 				popup();
 			}elseif ($_SESSION['my_key']< 1700)
 			{
 				//go back and add extra hour b4 scanning
 				add_time();
 			}
 
 		}
 
 
 	}
 
 	function write_meet()
 	{	// connect to db
 		db();
 
		 // declare variable to count number of records inserted
		 $_SESSION['kount']=1;
 
		 // accept the $_SESSION variables
 		 FOREACH ($_SESSION['check_array'] as $check_array){
 
		 $event_date = $_SESSION['meet_date']; 
		 $timeStart = $_SESSION['stime'];  
		 $timeEnd = $_SESSION['etime'];
		 $location = $_SESSION['locate'];
		 $agenda = $_SESSION['mdescription'];
		 $emp_no = $check_array; 
		 $originator = $_SESSION['emp_numb'];
 
		 /**
  		  * insert the above details into the db
    	*/
 
		 $sql="INSERT INTO event ( event_id, event_date, timeStart, timeEnd, location, agenda, emp_no, originator)
		 VALUES 
		 ('Null','$event_date','$timeStart','$timeEnd','$location','$agenda','$emp_no','$originator')";
 
		 $_SESSION['kount']++;
 
		 }
 
		 // close db
		 if (!mysql_query($sql,$met))
  		{
   		 die('Error: ' . mysql_error());
 		 }
   		mysql_close($met);
 
   		echo "\n\n\t\t\t\t\t\t\t\tRecord Added";
 
		// send control to monthly.php
		header('location:my_meeting.php');
 	}
 
 	function popup()
 	{
 		// pop up window after pressing ok send control to my_meeting for change of date.
 		echo "\n\n\t\t\t\tSorry, Auto Fix of your Meeting request\n";
		echo "\t\t\t\tIs not Possible until you change\n";
		echo "\t\t\t\tyour date for the event ";
 
 		?>
 		<html>
		<form method="post" action="my_meeting.php">
	 	<p><input type="submit" name="fix_eror" value="OK"></p></form>
		 </html>
		<?php
 	}
 
}
}
 
?>

if ($crazy==0)
 		{ // insert record into event
 			$this->write_meet();
 		}elseif($crazy>0)

class Mfix{
 
 	function db()
 	{
 		$met = mysql_connect("","","");
   		if (!$met)
   		{
       		die('Could not connect: ' . mysql_error());
    	}
    	mysql_select_db("", $met);
 
 	}
 
 	function max_time()
 	{
 		FOREACH($_SESSION['$endt'] as $key => $val)
 		{
 			if ($val == max($_SESSION['$endt']))
 			{
 				$_SESSION['my_key'] = $key;
 			}
 		}
 
 		$this->add_time();
 	}
 
 	function add_time()
 	{
 		}elseif ($_SESSION['my_key']<= 1700)
 		{
 			// do the new scan
 			$this->scan();
 		}
 	}
 	function scan()
 	{
 		// connect to db
 		$this->db();
 
		 /**
  		  * query the db
    	*/
 		 $crazy=mysql_num_rows($result);
 
 		if ($crazy==0)
 		{ // insert record into event
 			$this->write_meet();
 		}elseif($crazy>0)
 		{
 		// check value of $_SESSION['my_key']
 			if ($_SESSION['my_key'] >= 1700)
 			{
 			// end of the road - report can't continue with auto fix unless date is changed
 				$this->popup();
 			}elseif ($_SESSION['my_key']< 1700)
 			{
 				//go back and add extra hour b4 scanning
 				$this->add_time();
 			}
 		}
  	}
 	function write_meet()
 	{	// connect to db
 		$this->db();
 
		 // declare variable to count number of records inserted
		 // accept the $_SESSION variables
 		etc 
 	}
 	function popup()
 	{
 		// after pressing ok send control to meeting for change of date.
 		etc
 	}
 }
}