[Order query results by columns]

Hello,

 

I\'m trying to order a mysql query by column, not by rows.

Let\'s say I have 6 results, so I want to output on screen smth. like:

 

1 | 4

2 | 5

3 | 6

 

and NOT like:

 

1 | 2

3 | 4

5 | 6

 

 

 

The code I currently use is [results are ordered in 2 columns]:

 

 

<TABLE width="85%" ALIGN="CENTER">

   <tr><td class="barre"> <font class="lien"><a href="../">Linkuri.ro</a> <? echo $a[0]; ?></font> </td></tr>

   <tr><td  class="barreclair">< </td></tr>

   <tr><td><?	





if ($ad==1) $query="SELECT * FROM $tablecatannu WHERE attach=\'$num\' ORDER BY $tri_cat ASC";

 else $query="SELECT * FROM $tablecatannu WHERE attach=\'$num\' AND actif=\'1\' ORDER BY $tri_cat ASC";

$result=mysql_query($query); if (!$result) { echo "<BR><FONT class=\'texte\'>Error!</FONT><BR>"; exit(); }

$n=mysql_numrows($result);

echo "<TABLE align=\'center\' width=\'85%\'>";

for ($i=0; $i<$n-1; $i=$i+2)

 { //left column

 $nom=mysql_result($result,$i,"nom");

 $num2=mysql_result($result,$i,"id");

 $description=mysql_result($result,$i,"description");

 $im=mysql_result($result,$i,"im");

 $actif=mysql_result($result,$i,"actif");	

 $nb_tot=mysql_result($result,$i,"nb_tot");

 $sous_cat=mysql_result($result,$i,"sous_cat");

 echo "<TR><TD width=\'40%\' align=\'left\'>";

 affcat($num2,$nom,$actif,$ad,$nb_tot,$im);

 if ($sous_cat!="") echo "<FONT class=\'lienp\'>$sous_cat</FONT>";

 echo "</TD>";

 //right column

 $nom=mysql_result($result,$i+1,"nom");

 $num2=mysql_result($result,$i+1,"id");

 $description=mysql_result($result,$i+1,"description");

 $im=mysql_result($result,$i+1,"im");

 $actif=mysql_result($result,$i+1,"actif");

 $nb_tot=mysql_result($result,$i+1,"nb_tot");

 $sous_cat=mysql_result($result,$i+1,"sous_cat");

 echo "<TD width=\'40%\' align=\'left\'>";

 affcat($num2,$nom,$actif,$ad,$nb_tot,$im);

 if ($sous_cat!="") echo "<FONT class=\'lienp\'>$sous_cat</FONT>";

 echo "</TD></TR>";

 }

if ($n%2==1) 

 {

 $nom=mysql_result($result,$n-1,"nom");

 $num2=mysql_result($result,$n-1,"id");

 $description=mysql_result($result,$n-1,"description");

 $im=mysql_result($result,$n-1,"im");

 $actif=mysql_result($result,$n-1,"actif");

 $sous_cat=mysql_result($result,$n-1,"sous_cat");

 $nb_tot=mysql_result($result,$n-1,"nb_tot");

 $size=100-strlen($nom);

 echo "<TR><TD width=\'$size%\' colspan=\'2\'>";

 affcat($num2,$nom,$actif,$ad,$nb_tot,$im);

 if ($sous_cat!="") echo "<FONT class=\'lienp\'>$sous_cat</FONT>";

 echo "</TD></TR>";

 }

 

echo "</TABLE>";

 

 

 

Any ideas?

 

Thanks