[Resolved] printing db data

[pjleonhardt]

its been a long time since ive tried to do this, and i cant find an example of it that I've done before... so i have:

$entryid = $_GET['id'];
require("dbconnect.php");
$_comments = "SELECT * from blogcomments WHERE blogentryid = $entryid ORDER BY id DESC";
$get_comments = mysql_query($_comments) or die ("Little Error" . mysql_error());
$c = mysql_fetch_array($get_comments);
echo "<div class=\"commentPane\">";
print_r("<div class=\"comments\">".$c['date'] . "<br>" .$c['author'] . " Wrote: <br>" . ereg_replace('[\]', "", $c['comment'])."</div><br><Br>");
echo "</div>";

what im trying to do is display all the results from the database query, but it's only showing one. Help please 🙂

[Weedpacket]

You're only fetching one row. You'll need to put that in a loop to fetch the rest.

[pjleonhardt]

well.. i was looking through the manual.. and i found something like this:

while ($c = mysql_fetch_array($get_comments, MYSQL_ASSOC)) {
printf ("Date: %s Name: %s", $c["date"], $c["author"]);
}

however, this is still only returning one row. this time the first row instead of the last..

[pjleonhardt]

sweet..
i just changed it to a do{} while() instead of a while{} loop and it works now.

🙂
thanks