simple mysql output question (newbie)

Hi
Yep this one is stoopid but why can't I output this information to my page. It is a simple mysql select.....

Check this out, oh I am a beginner mysql php by the way. Very green.

include ("phpmodules/dbfuncs.inc");
$link = connectToDatabase();
if(!$link)
{
print "database connection error";
mysql_close($link);
exit();
}

$query = "select * from TBArticle";

$result = mysql_query($query);

$myrow = mysql_num_rows($result);

for($i = 0; $i < sizeof($myrow); $i++)
{
echo "$myrow";
}

Mmmm really need advice with some of this stuff I think...
Thanks for any advice.

mysql_num_rows is just returning the total number of rows in the query result.

i believe you're looking for the mysql_fetch_* functions

while ($row=mysql_fetch_array($query_result)){

echo $row['id'] . ' ' . $row['name'] . '<br>';

}

Hopefully that gets you on your way. 😃

problem solvered. thanks

This is what worked....

$result = mysql_query("select * from members");

		 $rows = mysql_num_rows($result);
		 for ($i = 0; $i < $rows; $i++)
		 {
		     $data = mysql_fetch_row($result);
				 echo "$data[0]";
		 }