View guestbook
Latest 3 guestbook entries...
$rs = @mysql_connect( "localhost", "userName", "password" )or die( "Could not connect to MySQL" );
$rs = @mysql_select_db( "my_database" ) or die( "Could not select database" );
$sql = "select * from guestbook order by time desc limit 3";
$rs = @mysql_query( $sql ) or die( "Could not execute SQL query" );
while ( $row = mysql_fetch_array( $rs ) )
{
?>
Name:
Email: ">
$datetime = $row["time"];
$year = substr( $datetime, 0, 4 );
$mon = substr( $datetime, 4, 2 );
$day = substr( $datetime, 6, 2 );
$hour = substr( $datetime, 8, 2 );
$min = substr( $datetime, 10, 2 );
$sec = substr( $datetime, 12, 2 );
$orgdate = date("l F dS, Y h:i A",mktime( $hour, $min, $sec, $mon, $day, $year ) );
?>
Date:
Comments: