***SOLVED *** query works fine on console but not with PHP ***SOLVED***
| From: | Aaron Wolski | Date: | Sun, 03 Aug 2003 14:25:49 +0000 |
| Subject: | ***SOLVED *** query works fine on console but not with PHP ***SOLVED*** | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29647@lists.php.net to get a copy of this message | ||
Hi,
Seem to still be getting responses to this question. I don't want people
to take time out from what their doing to answer a question that is now
solved.
Just trying to help save some people the time and effort from their own
development.
Much appreciated answers though. They'll help me in future debugging.
Thanks again to all.
Aaron
-----Original Message-----
From: Aaron Wolski [mailto:aaronjw@martekbiz.com]
Sent: August 3, 2003 10:08 AM
To: 'Matt'; 'php-db@lists.php.net'
Subject: RE: [PHP-DB] query works fine on console but not with PHP -
why? SOLVED
Hi and thanks,
Actually.. there was a typo in an if() statement just prior to it that
checked to see if a variable was set before proceeding with the query.
What a dumb-ass I am. You know you've been working way to long when you
can't do simple things.
Thanks for your comments!
Aaron
-----Original Message-----
From: Matt [mailto:hj611@epooch.com]
Sent: August 3, 2003 10:11 AM
To: Aaron Wolski; php-db@lists.php.net
Subject: Re: [PHP-DB] query works fine on console but not with PHP -
why?
----- Original Message -----
From: "Aaron Wolski" <aaronjw@martekbiz.com>
To: <php-db@lists.php.net>
Sent: Sunday, August 03, 2003 9:59 AM
Subject: [PHP-DB] query works fine on console but not with PHP - why?
> The error I am getting on the browser is:
>
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> result resource in http://www.martekbiz.com/KCS/utils.inc on
> line 52
>
> Anyone have an idea as to what it up?
Try:
echo mysql_error();
and see what mysql says.