Display data in a table.

[Ph0eniX]

How do you loop through records to display data in a table in PHP?

In VB it would look like this:

Do while Not RSobj0.EOF
Response.Write (RSobj0(0))
RSobj0.MoveNext
Loop

[barand]

with a mySQL database it would be something like

$result = mysql_query($query_string);
while ($row = mysql_fetch_array($result)) {
  echo "<tr><td>$row["fieldname1"]</td><td> $row["fieldname2"] </td></tr>" 
}
mysql_free_result($result);

to read the reults and put them in a table rows.

hth

[Ph0eniX]

Originally posted by barand
with a mySQL database it would be something like

$result = mysql_query($query_string);
while ($row = mysql_fetch_array($result)) {
  echo "<tr><td>$row["fieldname1"]</td><td> $row["fieldname2"] </td></tr>" 
}
mysql_free_result($result);

to read the reults and put them in a table rows.

hth [/B]

Gracias, sir! 😃