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:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 05:34 PM
To: SteveH; [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
