Loop through a recordset and display data in two columns

raevian

Hi, I have a table made up of two columns. I want to loop through a recordset and display the data in the two columns. How would you do this??

thanks!

Sep 19 '07 #1

brettl

I'm not sure if this is what you're asking for.

Sep 19 '07 #2

karlectomy

This might be a little faster.

$result = mysql_query($quString);
$row = mysql_fetch_assoc($result);

echo("<table><tr><td>Column 1</td><td>Column 2</td></tr>");

for($i = 0; $i < sizeof($arr); $i++)
{
echo("<tr><td>$row[$i]['Col1name']</td><td>".$row[$i]['Col2name']."</td></tr>");
}
echo("</table>");

Sep 19 '07 #3

raevian

thanks for the reply.but i am going to get the data from the same column in the database and display them in two columns in my html table. help please.thanks!

Sep 20 '07 #4

code green

Congratulations on wasting two members valuable time by asking completely the wrong question

Sep 20 '07 #5

karlectomy

I'm really confused: why would you want the same data in two columns in the same table?

anyways, Here's some code

[PHP]
$result = mysql_query($quString);
$row = mysql_fetch_assoc($result);

echo("<table><tr><td>Column 1</td><td>Column 1 Again?</td></tr>");

for($i = 0; $i < sizeof($arr); $i++)
{
echo("<tr><td>$row[$i]['Col1name']</td><td>".$row[$i]['Col1name']."</td></tr>");
}
echo("</table>");
[/PHP]

Sep 20 '07 #6