displaying array results in table

[Anon]

Hi there,

I'm a novice, so please bear with me. My array results are working fine, and I'd like to display them in a tabular format, but I can't seem to get it to work.

for ($i=0; $i <$num_results; $i++){
$row = mysql_fetch_array($result);
echo "<p><font size=2><strong>".($i+1).". Alias: </strong></font>";
echo htmlspecialchars( stripslashes($row["alias"]));
echo "<br><strong><font color=green>Alias Destination: </font></strong>";
echo htmlspecialchars( stripslashes($row["destination"]));
echo "<br><strong><font color=blue>Username: </font></strong>";
echo htmlspecialchars( stripslashes($row["username"]));
echo "</p>";

I'd like Alias, Alias Destination & Username to be column headings & the results to display underneath. If anyone can point me in the right direction, I'd really appreciate it! Thanks - georgie

[Anon]

http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=81

[Anon]

before you run through the array, output the headings:

echo "<TR><TD><strong>Alias: </strong></TD><TD>Alias Destination</TD><TD>Username</TD></TR>";

then get the array info using a while loop:
while($row = mysql_fetch_array($result)){
echo "<TR><TD>$row[Alias]....etc.....</TD></TR>";
}

[Anon]

exactly what i was looking for - thanks for the link

[Anon]

this works great! thank you, thank you!

[Anon]

Actually, you can just use <TH> tags instead:

echo "<TR><TH>Alias: </TH><TH>Alias Destination</TH><TH>Username</TH></TR>";