<? $pquery = "SELECT problem_list.code,freetext,problems.DESC1,stopdate,problem_list.problem_id from problem_list, problems where patient_id='$patid' AND problem_list.code = problems.code ORDER BY stopdate DESC"; $prcp = mysql_query($pquery); ?> <TABLE BORDER="2" CELLPADDING="0" CELLSPACING="0" WIDTH="100%" ALIGN="CENTER"> <TR> <? while ($row = mysql_fetch_array($prcp)) { echo "<TR><TD><INPUT TYPE=\"Checkbox\" NAME=\"del[]\" VALUE=\"$row[4]\"></TD><TD><FONT COLOR=\"WHITE\">  $row[0]</FONT></TD><TD><FONT COLOR=\"#FFFF99\">  $row[2]</FONT></TD><TD><FONT COLOR=\"darkblue\">  $row[1]</FONT></TD><TD><FONT COLOR=\"EEFF99\">  $row[3]</FONT></TD></TR>"; } ?> </TABLE> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php