17. september 2001 - 21:42
Der er
2 kommentarer og 1 løsning
Hvordan få jeg...
Jeg har den kode som virker men den skrive bare 0 timer og 0 min. kan ik få den til at hente det ned fra min mysql. <? $select_top15 = mysql_query(\"SELECT user_name,user_onlinetid,user_id FROM tinychat_user ORDER BY user_onlinetid DESC LIMIT 15\"); while($row_top15 = mysql_fetch_array($select_top15)) { $hour = floor($row_info[user_onlinetid]/60/60); $tempmin = $row_info[user_onlinetid]/60; $min = floor($tempmin-$hour*60); print \"<table width=100%> <tr> <td width=40%>( ID $row_top15[user_id] )<br></td> <td width=18%>$row_top15[user_name] <p align=center>-</td> <td width=42%> <p align=right>$hour timer og $min minutter.<br></td> </tr> </table> \"; } if ($id) { } if (!$valign) { $valign=\"top\"; } ?>
Annonceindlæg fra Computerworld
17. september 2001 - 21:51
#1
<? $select_top15 = mysql_query(\"SELECT user_name,user_onlinetid,user_id FROM tinychat_user ORDER BY user_onlinetid DESC LIMIT 15\"); while($row_info = mysql_fetch_array($select_top15)) { $hour = floor($row_info[user_onlinetid]/60/60); $tempmin = $row_info[user_onlinetid]/60; $min = floor($tempmin-$hour*60); print \"<table width=100%> <tr> <td width=40%>( ID $row_info[user_id] )<br></td> <td width=18%>$row_info[user_name] <p align=center>-</td> <td width=42%> <p align=right>$hour timer og $min minutter.<br></td> </tr> </table> \"; } if ($id) { } if (!$valign) { $valign=\"top\"; } ?>
17. september 2001 - 22:02
#2
<? $select_top15 = mysql_query(\"SELECT user_name,user_onlinetid,user_id FROM tinychat_user ORDER BY user_onlinetid DESC LIMIT 15\"); while($row_info = mysql_fetch_array($select_top15)) { $done = 60; $hour = 0; while($row_info[user_onlinetid]>($done+60)) { $hour = $hour+1; $done = $done+60; } $min = $row_info[user_onlinetid]-$done; print \"<table width=100%> <tr> <td width=40%>( ID $row_info[user_id] )<br></td> <td width=18%>$row_info[user_name] <p align=center>-</td> <td width=42%> <p align=right>$hour timer og $min minutter.<br></td> </tr> </table> \"; } if ($id) { } if (!$valign) { $valign=\"top\"; } ?>