require( "function.php" ); if( !isset( $page ) ) $page = 1; dbConnect(); $result = mysql_query( "SELECT id FROM geyspco_pabbi" ) or error( mysql_error() ); $totalMsg = mysql_num_rows( $result ); unset( $result ); if( $totalMsg <= $maxMsg ) $totalPages = 1; elseif( $totalMsg % $maxMsg == 0 ) $totalPages = $totalMsg / $maxMsg; else $totalPages = ceil( $totalMsg / $maxMsg ); if( $totalMsg == 0 ) $msgStart = 0; else $msgStart = $maxMsg * $page - $maxMsg + 1; if( $page == $totalPages ) $msgEnd = $totalMsg; else $msgEnd = $maxMsg * $page; $initialMsg = $maxMsg * $page - $maxMsg; $result = mysql_query( "SELECT name, vote, email, url, msg, datetime FROM geyspco_pabbi ORDER BY datetime DESC LIMIT $initialMsg, $maxMsg" ) or error( mysql_error() ); vote(); // displayHeader( "$guestbookName" ); ?> |
|
if( $totalMsg != 0 ):
while( $row = mysql_fetch_array( $result ) )
{
echo " Name: ${row['name']} -
( ${row['email']}) "; } else: echo " NO MESSAGE CURRENTLY, SING UP NOW!"; endif; ?> |