Query

[email protected] (Ron Piggott)
Newsgroups php.db
Organization Acts Ministries Christian Evangelism
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.