$q=mysql_query("SELECT * FROM jobscats ORDER by jcORDER ASC",$c);

print "<b>Centrum Pracy</b><br />

<table width='75%'><tr><th>Zadanie</th><th>Kosz P&N</th><th>Wykonaj</th></tr>";

while($r=mysql_fetch_array($q))

{

print "<tr><td colspan='3'>".$r['jcNAME']."</td></tr>";

$q2=mysql_query("SELECT * FROM jobs WHERE jobCAT=".$r['jcID']."",$c);

while ($r2=mysql_fetch_array($q2))

{

print "<tr><td>".$r2['jobNAME']."</td><td>".$r2['jobPiN']." P&N</td><td><a href='job-go.php?c=".$r2['jobID']."'>Wykonaj</a></td></tr>";

}

}