Data Format

[Anon]

Hello,

My data is pulling fine from the database but it's doing so in a row, like so:

Name Address State

Name Address State

Name Address State

What I need it to do is show up in a column like so:

Name | Name | Name
Address | Address | Address
State | State | State

Should I be doing something with NumCols? I'm a newbie and I'm completely lost. Please help. 🙂

[pacmon]

Could do it like this:
int i=0;
while(list($name,$address,$state)=mysql_fetch_row($result))
{
$namear=$name;
$addrar=$address;
$statear=$state;
}

then simply print them out in columns like:
echo "<table><tr>"
for($i=0;$i < count($namear);$i++)
{
echo "<td>$namear</td>";
}
echo "<tr>";
for($i=0;$i < count($addrar);$i++)
{
echo "<td>$addrar</td>";
}
echo "<tr>";
for($i=0;$i < count($statear);$i++)
{
echo "<td>$statear</td>";
}
echo "</table>";