here is my loop code for my guestbook:
Code: Select all
$results = mysql_query("SELECT * FROM gbtable");
$NumOfRows = mysql_numrows($results);
$r = $NumOfRows;
while($r > 0)
{
--$r;
$r_Nick = mysql_result($results, $r, 'Nick');
$r_Nick_IP = mysql_result($results, $r, 'Nick_IP');
$r_Email = mysql_result($results, $r, 'Email');
$r_Body = mysql_result($results, $r, 'Body');
$r_PostDate = mysql_result($results, $r, 'PostDate');
ShowComment($r_Nick, $r_Nick_IP, $r_Email, $r_Body, $r_PostDate); #this just prints out a table with the info.
}