getting data into two columns

Anon

Hi,

I'm having difficulty getting my data into two columns because I want the data to be displayed in order going down, then across.

Basically it's a simple menu with 10 items. I want it to look like:

| 1 | 6 |
| 2 | 7 |
| 3 | 8 |
| 4 | 9 |
| 5 | 10 |

It's difficult because HTML programs it's rows across then down, and I want to go down and then across.

ANy help greatly appreciated.

Thanks all,
Caleb

mistcat

since you know how many items there are, why don't you just do something like this?

for($i=0;$i<sizeof($array);$i++) {
print "<TR>";
print "<TD>".$array[$i]."</TD><TD>".$array[($i+5)]. "</TD>";
print "</TR>";

}

Anon

Sounds good nate.

Now what if I have two fields per row in my table?

eg

and so on...

Thanks,
Caleb
ps. I am pretty much still a newbie, in case you haven't figured that out already!

Anon

Just output the second array with the first one:

for($i=0;$i<sizeof($array);$i++) {
print "<TR>";
print "<TD>".$array[$i]. " " . $array2[$i] . "</TD><TD>".$array[($i+5)]. " " . $array2[$i+5] . "</TD>";
print "</TR>";

}

Anon

All I get is the first row from the table, and no more.

Here is my code:
$sql = mysql_query("SELECT no FROM vet.$id2 ORDER BY no",$db);
$sql2 = mysql_query("SELECT item FROM vet.$id2 ORDER BY no",$db);
$myrow = mysql_fetch_array($sql);
$myrow2 = mysql_fetch_array($sql2);
for($i=0;$i < count($myrow);$i++) {
print "<TR>";
print "<TD>".$myrow[$i]. " " . $myrow2[$i] . "</TD><TD>".$myrow[($i+17)]. " " . $myrow2[$i+17] . "</TD>
";
print "</TR>";

}

Anon

That's because you're fetching the array outside the loop. It should be:

for($i=0;$i < count($myrow);$i++) {
$myrow = mysql_fetch_array($sql);
$myrow2 = mysql_fetch_array($sql2);
print "<TR>";
print "<TD>".$myrow[$i]. " " . $myrow2[$i] . "</TD><TD>".$myrow[($i+17)]. " " . $myrow2[$i+17] . "</TD>
";
print "</TR>";
}

Also, instead of two queries, you could have done this:
$sql = mysql_query("SELECT no, item FROM vet.$id2 ORDER BY no",$db);

Diego

Anon

Thanks Diego!