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