Query
| From: | Ron Piggott | Date: | Thu, 01 May 2008 02:04:38 +0000 |
| Subject: | Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44940@lists.php.net to get a copy of this message | ||
I have an interesting question.
When I run the following query through my PHP script it produces 1
result. I know this because I echo the value of $num to the screen from
the following syntax: $num=mysql_numrows($result);
When I do the query in the "SQL" tab of phpMyAdmin there are 6 results.
The 6 requests are correct.
Any ideas why I have 2 different search results?
Ron
SELECT * FROM ministry_directory INNER JOIN
ministry_directory_listing_categories ON ministry_directory.entry =
ministry_directory_listing_categories.ministry_directory_entry WHERE
ministry_directory.listing_type = 2 AND
ministry_directory_listing_categories.ministry_directory_category_reference IN ( 10 ) ORDER BY
ministry_directory.name ASC