Re: Search Query on two tables not working
| From: | Dan Shirah | Date: | Tue, 21 Jul 2009 17:11:23 +0000 |
| Subject: | Re: Search Query on two tables not working | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-295630@lists.php.net to get a copy of this message | ||
On Tue, Jul 21, 2009 at 12:41 PM, Miller, Terion <
tmiller@springfi.gannett.com> wrote:
> Turned off the redirects on the whole script and tried to the the query to
> echo and these are the errors I got:
>
> Notice: Undefined offset: 1 in /var/www/vhosts/
> getpublished.news-leader.com/httpdocs/ResturantInspections/processRestaurantSearch.phpon line
> 89
>
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
> resource in /var/www/vhosts/
> getpublished.news-leader.com/httpdocs/ResturantInspections/processRestaurantSearch.phpon line
> 119
>
>
> On 7/21/09 11:32 AM, "Kevin Smith" <kevin@netsmith.ltd.uk> wrote:
>
> Can you supply the actual generated SQL, I can potentially see a
> problem, but need to see the final SQL statement.
>
> print_r($sql);