this is my code
Code: Select all
<?php
// Connecting, selecting database
mysql_connect('localhost', 'madashat_eric', 'gateway2')
or die('Could not connect: ' . mysql_error());
mysql_select_db('madashat_blog') or die('Could not select database');
echo "<BR>";
$blogid = $_GET['blogid'];
$query = "select * from comments order by id desc where blogID = '$blogid'";
$result = mysql_query($query) or die(mysql_error().'<br />'.$query);
$number_of_rows = mysql_num_rows($result);
for ($i = 0; $i < $number_of_rows; ++$i)
{
$id = mysql_result($result,$i,"id");
$name = mysql_result($result,$i,"name");
$date = mysql_result($result,$i,"date");
$time = mysql_result($result,$i,"time");
$comment = mysql_result($result,$i,"comment");
echo "<h2>".$date." :: ".$time."</h2>
<h1>".$name."</h1>
<BR>".$comment."<br>";
}
?>would be greatfull for advise
Eric