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