How's this? (MYSQL example)
$query = "select NAME from table_name";
$result = mysql_query($query)
or die("Invalid Query: $query");
$num_rows = mysql_num_rows($result);
$counter=1;
echo "<table border=1><tr>"; //start of table
for ($i=0;$i<$num_rows; $i++) //loop through the number of records
{
$row = mysql_fetch_array($result); //Get associate row
echo "<td>$row[0]</td>"; //Print out the NAME
if ($counter == 2)
{
echo "</tr><tr>"; //Make a new Table row
$counter=1; //Reset Counter
}
else
{
$counter++; //Just increment the counter
}
}
echo "</tr></table>";
mysql_free_result($result);
HTH
-Brad
[EMAIL PROTECTED] wrote:
> Hi..
>
> I'm creating a database result in a table, but I need to put it into 2
> columns of looping row like this:
>
> |name1 |name2 |
> |name3 |name4 |
> |name5 |name6 |
> |name7 |name8 |
> |name9 |name10 |
> etc...
>
> can anyone help me please...
>
> iman
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
