Re: [PHP-DB] 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.