An easy one... (MySQL + PHP)

Anon

I have another (easy) problem:

$result = mysql_query("SELECT * FROM posts WHERE topic_id = '$topic' ORDER BY post_id ASC");
$myrow_message = mysql_fetch_array($result);

and the question is how to get each post (one by one) to ECHO them...
They are ordered ASC...but how to get each post

the posts table (MySQL) looks like this:

posts (
post_id int(10) NOT NULL auto_increment,
image varchar(100) DEFAULT '' NOT NULL,
topic_id int(10) DEFAULT '0' NOT NULL,
forum_id int(10) DEFAULT '0' NOT NULL,
poster_id int(10),
post_text text,
post_time varchar(20),
poster_ip varchar(16),
PRIMARY KEY (post_id)
);

brandonschnell

$result = mysql_query("SELECT * FROM posts WHERE topic_id = '$topic' ORDER BY post_id ASC");

while($myrow_message = mysql_fetch_array($result))
{
echo "post_id: ",$myrow_message["post_id"]," \n";
echo "image: ",$myrow_message["image"]," \n";
echo "topic_id: ",$myrow_message["topic_id"],"\n";
echo "forum_id: ",$myrow_message["forum_id"],"\n";
echo "poster_id: ",$myrow_message["poster_id"],"\n";
echo "post_text: ",$myrow_message["post_text"],"\n";
echo "post_time: ",$myrow_message["post_time"],"\n";
echo "poster_ip: ",$myrow_message["poster_ip"],"\n";
}

Anon

if ($myrow_complete = mysql_fetch_array($result)) {

echo "<table border=1>\n";

echo "<tr><td>Post id</td><td>Image</td><td>Topic ID</td><td>Forum ID</td><td>Poster ID</td><td>Post Text</td><td>Post Time</td><td>Poster IP</td></tr>\n";

do {

printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</tr>\n", $myrow_complete["post_id"], $myrow_complete["image"], $myrow_complete["topic_id"], $myrow_complete["forum_id"], $myrow_complete["poster_id"], $myrow_complete["post_text"], $myrow_complete["post_time"], $myrow_complete["post_ip"]);

} while ($myrow_complete = mysql_fetch_array($result));

echo "</table>\n";}

[deleted]

Nice approach, no table printed if no results are available.
Missing the closing } for the IF though.