need this to put 2 columns

[Anon]

I have a piece of code that works (well in fact) but I need it to output in 2 columns. ie. first record in first column, second record in second column, third record in first column ... Here is the code that I have:

if ($myrow = mysql_fetch_array($result)) {

echo "<table align=center border=2>\n";

do {

if ($myrow[jobstatus] == 'Active') {

printf("<tr><td><b>%s</b></td></tr>\n", $myrow["jobtype"]);
printf("<tr><td>%s</td></tr>\n", $myrow[jobtitle]);

printf("<tr><td>%s.<br> %s.<br> %s.</td></tr>\n", $myrow["jobreq"], $myrow["jobdesc"], $myrow["workhours"]);

}

} while ($myrow = mysql_fetch_array($result));

do {

} while ($myrow = mysql_fetch_array($result));

    echo "</table>\n";

Any help will be much appreciated.

[[deleted]]

First, change all those horrible do{} ..while loops
into while{} loops.

Second, printing different lines simply means printing an "end of line / begin of new line" after every two records.

So, if you put a small counter in you can use that to decide if you are printing the first or the second record of that particular line.