Multiple columns

[Anon]

I have written a piece of PHP code to pull info out of my MySQL database. It does this just as expected, the problem is I need the output in 2 columns instead of one. Can anyone help me to get 2 columns out of this:

<?php

if ($hours = "All" || $jobstatus = "Active") {

$db = mysql_connect("localhost", "root");

mysql_select_db("hprhs",$db);

$result = mysql_query("SELECT * FROM joblist ORDER BY jobtype",$db);

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));

[pallan]

What do you want in each column? If I understand what you mean, all you should have to do is remove the appropriate <TR> tags and another column would be born.

For example, if you want 'jobtype' and 'jobstatus' in separate columns just remove the </TR> tag from the first line and the <TR> tag from the secon liks so:

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

printf("<tr><td>%s</td>\n", $myrow["jobtype"]);
printf("<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));

Hope this helps

Peer