RE: [PHP-DB] Re: PHP-WIN MYSQL Double results
| From: | Hutchins, Richard | Date: | Thu, 30 Jan 2003 20:17:50 +0000 |
| Subject: | RE: [PHP-DB] Re: PHP-WIN MYSQL Double results | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25263@lists.php.net to get a copy of this message | ||
Try this:
After this line:
> $prcp = mysql_query($pquery);
add this line:
print_r($prcp);
(For additional info: http://www.php.net/manual/en/function.print-r.php)
What that should do is print the results directly from your query (which are
stored as an associative array) before anything else is done with it. So, if
your query is returning a single row in the MySQL monitor, and you expect it
to return the same thing when called from your script, print_r() should
confirm that for you.
If print_r returns double results, then there's a problem with your query.
If it doesn't then there's a problem further down in your code.
> -----Original Message-----
> From: Chris Deam [mailto:chrisdeam@deam.digitalhomeport.com]
> Sent: Thursday, January 30, 2003 3:07 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Re: PHP-WIN MYSQL Double results
>
>
> <?
> $pquery = "SELECT
> problem_list.code,freetext,problems.DESC1,stopdate,problem_lis
> t.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
>