Re: Little Problem with my Guestbook

Florian P. wrote:

<?php include("sql.inc.php"); include("config.inc.php"); $connection = mysql_connect($sql['host'],$sql['uid'],$sql['pwd']); $select_db = mysql_select_db($sql['db']); $select = mysql_query('SELECT * FROM comments'); $data = mysql_fetch_array($select); $result = mysql_query('SELECT * FROM comments'); $rows = mysql_num_rows($result); <snip>

No reason to run this twice.... $data = array(); if ( $result = mysql_query ( 'SELECT * FROM comments' ) ) { while ( $temp = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) { $data[] = $temp; } $rows = mysql_num_rows ( $result ); mysql_free_result ( $result ); } else { echo ( mysql_error() ); exit; } The returned rows will be in the $data array. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com