Show data from mysql in two columns php

[neonardo]

Hello

If I have the following code

if(!isset($_GET['id']))
{
$self = $_SERVER['PHP_SELF'];

$query = "SELECT id, nombre_of FROM oficinas ORDER BY id";
$result = mysql_query($query) or die('Error : ' . mysql_error());


$direccion = '<ol>';
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
list($id, $nombre_of) = $row;
$direccion .= "<li><a href=\"$self?id=$id\">$nombre_of</a></li>\r\n";
}
$direccion.= '</ol>';

As I can do in order that the data in a list with two columns be shown ?

Sorry, my english is not good
help me, please!!!!!!!

[php_daemon]

Ten rows per column:

if(!isset($_GET['id']))
{
$self = $_SERVER['PHP_SELF'];
 
$query = "SELECT id, nombre_of FROM oficinas ORDER BY id";
$result = mysql_query($query) or die('Error : ' . mysql_error());
 
 
$direccion = '<div style="float:left"><ol>';
$i=1;
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
list($id, $nombre_of) = $row;
if($i++&#37;10==0) $direccion .= '</ol></div><div style="float:left"><ol>';
$direccion .= "<li><a href=\"$self?id=$id\">$nombre_of</a></li>\r\n";
}
$direccion.= '</ol></div><br style="clear:both" />';

[neonardo]

not workink php_daemon

show list of data 1-9 in order list
10 - rest unorder list

and the rest of the list in unorder list, example

1 *
2 *
3 *
4 *
5 *
6 *
7 *
8 *
9 *

-
-
-
-
-

[php_daemon]

Well, I was kinda hoping you will adjust it to what you need; it's just the basic idea.

[neonardo]

thanks php_daemon

solved problem