help please.
Posted: Sat Jan 28, 2012 12:02 pm
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>";