Code: Select all
<?php// Make a MySQL Connectionmysql_connect("localhost", "log", "pw") or die(mysql_error());mysql_select_db("db") or die(mysql_error()); // Get all the data from the "example" table$result = mysql_query("SELECT * FROM log_connect") or die(mysql_error()); date_default_timezone_set('UTC');echo "<table border='1'>";echo "<tr> <th>IP</th> <th>Nick</th> <th>Time</th> </tr>";// keeps getting the next row until there are no more to getwhile($row = mysql_fetch_array( $result )) { // Print out the contents of each row into a table echo "<tr><td>"; echo $row['ip']; echo "</td><td>"; echo $row['nick']; echo "</td><td>"; echo $row['time']; echo "</td></tr>";} echo "</table>";?>Code: Select all
echo date('l jS \of F Y h:i:s A');Code: Select all
echo $row['time'];Code: Select all
echo date('l jS \of F Y h:i:s A', $row['time']);