RE: [PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Hutchins, Richard
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

Re: [PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Chris Deam
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

Re: [PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Chris Deam
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: