Re: Help needed after upgrading to PHP4
| From: | Kondwani Spike Mkandawire | Date: | Mon, 05 Aug 2002 14:40:18 +0000 |
| Subject: | Re: Help needed after upgrading to PHP4 | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111209@lists.php.net to get a copy of this message | ||
"Mirek Novak" <mirek.novak@auto.cz> wrote in message
news:3D4E7DE1.5070004@auto.cz...
> Hi,
> you are not connect to database (maybe), check lines with
mysql_connect() ... for error. You're may be using @mysql_connect to
> supress error messages so remove '@'.
>
I doubt its to do with connect, wouldn't a corresponding error have shown...
i.e. Something along the lines of cannot find DNS... Or error connecting
to....
> Tony Burgess wrote:
> > Hi Everyone,
> >
> > I'm quite new to all this PHP stuff, and was wondering if someone could
give
> > me some help with a problem I have.
> >
> > After upgrading from PHP3 I now get the following information displayed
> >
> > Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource
> > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result
> > resource
> >
Your error is most likely is to do with the SQL query supplied before the
fetch_array
statement you obviously had something that requested execution of a query as
follows:
$result = mysql_query("An SQL Command", $dataBaseNameSource);
Here is where lies your problem.... Make sure you are supplying a legit SQL
query
i.e. Check the "An SQL Command" syntax for legitimacy, For instance if you
are INSERTING
make sure number of arguements supplied equals number of fields indicated
for enrty
> > I think it may have something to do with the build, perhaps it's made
errors
> > whilst trying to build with mySQL. Any help would be much appreciated.
> >
> > --
> > Tony Burgess
> >
> >
> >
> >
>
>
>
> --
> --
> Mirek Novak
> Anima Publishers
> CMS development
>
> http://www.auto.cz
> http://www.formule1.cz
>
> jabber:mirek@njs.netlab.cz
> ISEEKYOU:1<one>9<four>9<nine>44<eight>
> GEsEm:+420603807838
>
Hope this helps,
Spike...