listing schedule time interval and client appointment
Hi

I am php newbie and I don't know if I am approaching this properly.
I need to creat a scheduler that list the appointment time on the left
and client for a specific appointment time on the left.


NOTE: The appointments are stored in a Mysql database

This is what I am trying to acomplish:
Time interval for appointments are 10 min or 15 min or 30 min, for
this example it is 60 mins

Time | client Name
-------------------------------------------
09:00 AM |
10:00 AM | John Smith
11:00 AM |
to
09:00 PM | Mike Smith



I am getting the time interval on the right to display,
The problem I am having is getting the client name to line up with the
appointment time intervals on the right.


This is what I am getting with the code below:


Time | client Name
------------------------------------------------
09:00 AM | John Smith
10:00 AM | Mike Smith
11:00 AM |
to
09:00 PM |



PHP Code:
<?
  /**--------------------------time interval--------------------**/
  //array with time interval listing found on the left side of the page
  $time_60min_array = array(
  '06:00 AM', '07:00 AM', '08:00 AM', '09:00 AM', '10:00 AM', '11:00 AM', 
  '12:00 PM', '01:00 PM', '02:00 PM', '03:00 PM', '04:00 PM', '05:00 PM', 
  '06:00 PM', '07:00 PM', '08:00 PM', '09:00 PM');
  
  /**-------------select appointment from database-----------------**/
  // select by date to match to time interval listing
  $query = "SELECT distinct(event_id), event_date, event_time, 
                         event_am_pm, first_name, last_name, 
              FROM cal_appointment 
          WHERE event_date = '$event_date'
          ORDER BY event_date, event_am_pm, event_time";

   $result = mysqli_query($mysqli, $query) or die('Error, query failed');
 
   /**-------------------------------title--------------------------**/    
  //Note:<html> open layers and <tables> tags and title goes here
     
    
 /**--------------------------display------------------------**/

     $result = mysqli_query($mysqli, $query) or die('Error, query failed');

     $row_count = count($time_60min_array);//count time interval in array

     for($i=0; $i < $row_count; $i++)
    {
        $row = mysqli_fetch_array($result); 
 
         list($event_id, $event_date, $event_time, 
                                $event_am_pm,$first, $last) = $row;
         
         
           //format time
          $appoint_time = $event_time." ".$am_pm;
        
          //time interval
          $interval =  $time_60min_array[$i];
 
              //match appointment time on right to time listing on left          
             if(in_array($appoint_time,  $interval))
          {
            $s_event_id = $event_id; 
                   $client_name = $last.", ".$first;
          }
        
        //display list
         echo"<tr height=\"10\">
        <td width=30% height=\"10\" bgcolor=\"$bgcolor\" 
                               align=\"center\">$interval</td>
        <td width=\"70%\"  height=\"10\" bgcolor=\"$bgcolor\"> 
                               <span class=\"style20\">$client_name</td>\n";
              echo"</tr>\n";
          }
          
          
  //Note: </html> end layers and </table>
?>