Prev: problem in creating the ibm_db2 extension
Next: Alternative for MySQL Admin tools
From: Ron Piggott on 30 Apr 2008 22:04
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

From: Chris on 30 Apr 2008 23:19
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.

From: Ron Piggott on 30 Apr 2008 23:39

You just drew my attention my <include that brings in the site menu and
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.
>

 | 
Pages: 1
Prev: problem in creating the ibm_db2 extension
Next: Alternative for MySQL Admin tools