List:General Discussion« Previous MessageNext Message »
From:Roger Davis Date:August 16 2002 1:12pm
Subject:RE: Supplied argument is not a valid MySQL result resource!!
View as plain text  
I don't know if you cut and pasted your code, if you did then try this.

$qid = mysql_query("SELECT * FROM 1_nodedata WHERE id = ".$edit_id.";");
$tr = mysql_num_rows ($qid);
echo $tr;

That should give us a count of the rows and it will make sure our query is
returning something.



-----Original Message-----
From: Anil Garg [mailto:anilg@stripped]
Sent: Thursday, August 15, 2002 05:34 PM
To: SteveH; mysql@stripped
Subject: Re: Supplied argument is not a valid MySQL result resource!!


hi,
m sorry i dint mention that its just a part of code.
i am able to delete entries from the database .so i think mysql_connect is
not the reason.
please tell if u have some more ideas

regards
anil
----- Original Message -----
From: "SteveH" <steveh@stripped>
To: <mysql@stripped>
Sent: Thursday, August 15, 2002 4:50 PM
Subject: Re: Supplied argument is not a valid MySQL result resource!!


> Anil,
>
> You never created a connection.
> mysql_connect()
>
>
> Regards.
>
>
>
>
>
> Thursday, August 15, 2002, 1:12:21 PM, you wrote:
>
> > Hi,
> > in the piece of code given below
> > -----------
> > $qid = mysql_query("
> >  SELECT *
> >  FROM 1_nodedata
> >  WHERE id = $edit_id
> >  ");
> >  $frm = mysql_fetch_array($qid);
> > -----------
> > i get the follownig error:
>
> > Warning: Supplied argument is not a valid MySQL result resource in
> > /z/mercury/www/niksun/admin/add_doc.php on line 107
> > element type:
>
> > What is it happening so!!
> > regards
> > anil
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread117228@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-anilg=niksun.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread117229@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-rdavis=zonecareusa.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Thread
Supplied argument is not a valid MySQL result resource!!Anil Garg16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!SteveH16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!Anil Garg16 Aug
    • Re: Supplied argument is not a valid MySQL result resource!!Dan Nelson16 Aug
    • RE: Supplied argument is not a valid MySQL result resource!!Roger Davis16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!Jocelyn Fournier16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!Anil Garg16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!Jocelyn Fournier16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!Anil Garg16 Aug
  • Re: Supplied argument is not a valid MySQL result resource!!Pekka Saarinen16 Aug