Query

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_ent ry WHERE
ministry_directory.listing_type = 2 AND
ministry_directory_listing_categories.ministry_directory_cat egory_reference IN ( 10 ) ORDER BY ministry_directory.name ASC


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Query

Ron Piggott wrote:
> 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?

Show us the php code.. maybe you're overwriting the $result variable in
your loop.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Query

You just drew my attention my was changing the conflict. Thanks :) Ron

On Thu, 2008-05-01 at 13:19 +1000, Chris wrote:
> Ron Piggott wrote:
> > 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?
>
> Show us the php code.. maybe you're overwriting the $result variable in
> your loop.
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php