zatial som neriesil kolko ma mesiac dni dal som do cyklu for 31. skusil som toto:
Kód:
session_start();
$emp_id = $_SESSION['emp_id'];
$sql = 'SELECT
e.emp_id, hours,
UNIX_TIMESTAMP(first_join) AS first_join,
UNIX_TIMESTAMP(last_join) AS last_join,
UNIX_TIMESTAMP(lunch_start) AS lunch_start,
UNIX_TIMESTAMP(lunch_stop) AS lunch_stop,
UNIX_TIMESTAMP(doc_go) AS doc_go,
UNIX_TIMESTAMP(doc_come) AS doc_come
FROM
emp e JOIN
emp_hours h ON e.emp_id = h.emp_id
WHERE
e.emp_id ="'. $emp_id. '"';
$result = mysql_query($sql, $db) or die(mysql_error($db));
for ($i = 1; $i <= 31; $i++){
$row = mysql_fetch_array($result);
extract($row);
if (date('d', $first_join) == $i){
echo '<tr><td>';
echo date('d', $first_join). '</td><td>';
echo date('D', $first_join). '</td><td>';
echo date('H:i:s', $first_join). '</td><td>';
echo date('H:i:s', $lunch_start). '</td><td>';
echo date('H:i:s', $lunch_stop). '</td><td>';
echo date('H:i:s', $doc_go). '</td><td>';
echo date('H:i:s', $doc_come). '</td><td>';
echo date('H:i:s', $last_join). '</td><td>';
echo $hours. '</td></tr>';
} else {
echo '<tr><td>';
echo date('d', $i). '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td><td>';
echo '-'. '</td></tr>';
}
}
ked tam nemam while tak mi to 17x hodi prazdny riadok a potom nacita len jeden. preco neodporucas pouzivat funkcie mysql?
// Spojený príspevok Pon 19.10.15 23:05porovnaval som tam cislo dna prichodu s premennou $i z cyklu.
