can anyone break this php code down for me?

  • Thread starter Thread starter funny t
  • Start date Start date
F

funny t

Guest
$query2 = "SELECT DATE_FORMAT(DATE_ADD(login_time,INTERVAL $time_diff HOUR), '%m/%d/%y'),DATE_FORMAT(DATE_ADD(login_time,INTERVAL $time_diff HOUR), '%l:%i%p'), DATE_FORMAT(DATE_ADD(logout_time, INTERVAL $time_diff HOUR),'%l:%i%p'), TIMEDIFF(logout_time,login_time) from session_login,user where user.userid=session_login.userid and user.userid=$userid and logout_time is not null $qual order by login_time";

$result2 = mysql_query($query2, $mysql_link) or die(mysql_error());
if ($result2)
{
print "<br><table border=1>";
print "<tr><th>Date</th><th>In</th><th>Out</th><th>hours:min</th></tr>";
while ($row2 = mysql_fetch_row($result2))
{
$date = $row2[0];
$login_time = $row2[1];
$logout_time = $row2[2];
$timediff = $row2[3];

print "<tr><td>$date</td><td>$login_time</td><td>$logout_time</td><td>$timediff</td></tr>";
}
print "</table>";
}
its a select statement that has some date formatting
 
Back
Top