Re: PHP-WIN MYSQL Double results

["Chris Deam" <chrisdeam@deam.digitalhomeport.com>]

<?
$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\">&nbsp
$row[0]</FONT></TD><TD><FONT COLOR=\"#FFFF99\">&nbsp
$row[2]</FONT></TD><TD><FONT COLOR=\"darkblue\">&nbsp
$row[1]</FONT></TD><TD><FONT COLOR=\"EEFF99\">&nbsp
$row[3]</FONT></TD></TR>";
}
?>
</TABLE>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php