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!

[brettl]

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

 
<?php
$data = array( array(
        col1 => 'col1a',
        col2 => 'col2a',
    ),
        array(
        col1 => 'col1b',
        col2 => 'col2b',
    ),
        array(
        col1 => 'col1c',
        col2 => 'col2c',
    ),
        array(
        col1 => 'col1d',
        col2 => 'col2d'
    )
    );
 
 
?>
 
 
<table>
    <tr>
        <td> Column1 </td>
        <td> Column2 </td>
    </tr>
 
<?php
foreach ($data as $hit) {
 
    print <<< _HTML_
        <tr>
            <td>$hit[col1]</td>
            <td>$hit[col2]</td>
        </tr>
_HTML_;
}
?></table>    
 

[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>");

[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!

[code green]

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

[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]