Page 1 of 1

help please.

Posted: Sat Jan 28, 2012 12:02 pm
by athlhaz
please help me with my codes i want the date align to output date here my code..

Code: Select all

include('../Connection/mysql_connect_attendance.php');
  
  $result = mysql_query("SELECT DISTINCT DATE_FORMAT(date,'%a') FROM tb_timeinandout") or die('Query failed!');
  
    echo "<table border = '1'";
    echo "<tr>";
    echo "<td align='center'></td>";
  while($row = mysql_fetch_array($result)) {
      // display field/column names as first row
    echo "<td align='center'>";
    echo "\t<b>" . $row[0] ."</b>";
    echo "</td>";
    }
    echo "<tr>";
    echo "<td align='center'></td>";
    
  $result1 = mysql_query("SELECT DISTINCT DATE_FORMAT(date,'%e-%b'), date FROM tb_timeinandout") or die('Query failed!');  
  $items = array();
  while($row = mysql_fetch_array($result1)) {
      // display field/column names as first row
    $items[] = $row[1];
    echo "<td align='center'>";
    echo "\t<b>" . $row[0] ."</b>";
    echo "</td>";
    }
  echo "</tr>";
  
  echo "<tr>";
  echo "<td bgcolor='orange' align='center'><b>Employees</b></td>";
  echo "</tr>";
    
  $result2 = mysql_query("SELECT DISTINCT Last_Name, First_Name, Middle_Name, Employee_No FROM tb_timeinandout WHERE User_Level = 'Employee'") or die('Query failed!');
  while($row = mysql_fetch_array($result2)) {
    // display field/column names as first row
    echo "<tr>";
    echo "<td align='center'>";
    echo "<b>" . utf8_decode($row[0]) . ", " . utf8_decode($row[1]) . " " . utf8_decode($row[2]) . "</b>\t";
    echo "</td>";
    
    $result1 = mysql_query("SELECT DISTINCT date FROM tb_timeinandout") or die('Query failed!');  
    while($row1 = mysql_fetch_array($result1)) {
        $result3 = mysql_query("SELECT DATE_FORMAT(date,'%e-%b'), date FROM tb_timeinandout WHERE User_Level = 'Employee' AND Employee_No = '$row[3]'") or die('Query failed!');
        
        $dates = array();
        while($row3 = mysql_fetch_array($result3)) {
           $dates[] = $row3[1]; 
        }
        

        $items = mysql_query("SELECT DISTINCT date FROM tb_timeinandout") or die('Query failed!');
        while($row = mysql_fetch_array($items)){
                
                foreach($dates as $newdates) {
                    if($row[0] == $newdates) {
                        
                            echo "<td>ok var_dump($row[0] $newdates)</td>"; //i got a problem when i output this. it doesn't align with my header
                         
                    }
                    
      
            }
            
            }
        
               
    }
            
            
            
    
    echo "</tr>";
  }
  
  echo "</table>";