How to echo a field content from each row from a mysql table?

Question

This script selects all the rows that i need but now how do i echo the fileds from each row that its found?



$connection = mysql_connect($host,$user,$password)
or die ("coudlnt connectto server.");
$db = mysql_select_db($database, $connection)
or die ("coulnt find database.");
$query = "SELECT * FROM CUSTO where PENDINGD=""";
$result = mysql_query($query)
or die ("yellow");
$num = mysql_num_rows($result);
$row = mysql_fetch_array($result);
extract($row);

Answer 1

believes the mysql_fetch_array function will do it might have to do something like

while ($row = mysql_fetch_array($result)){
echo $row['field_name'] . "
";
}

* interesting line breaks wonders about links

Answer 2

You need to assign each row of data to a display string, this can be the whole string as a table :
$display_string ="