Re: PHP-WIN MYSQL Double results
| From: | Chris Deam | Date: | Thu, 30 Jan 2003 20:07:09 +0000 |
| Subject: | Re: PHP-WIN MYSQL Double results | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25259@lists.php.net to get a copy of this message | ||
<?
$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>