?
$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%
Okay, I used print_r but now I get Resource Id #19 no sort of array info.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Okay, I kinda fixed it. I added the DISTINCT option to the sql query.
DISTINCT returns only one row when multiples arre found. What I don't
understand is that there is only one row returned in the MYSQL console.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: