Re: php mysql_num_rows problem
| From: | Pascal Polleunus | Date: | Wed, 27 Feb 2002 16:24:30 +0000 |
| Subject: | Re: php mysql_num_rows problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-86428@lists.php.net to get a copy of this message | ||
with insert, update and delete you must use mysql_affected_rows()
http://www.php.net/manual/en/function.mysql-affected-rows.php
----- Original Message -----
From: "Rodrigo Peres" <rperes@mac.com>
To: "PHP" <php-general@lists.php.net>
Sent: Wednesday, February 27, 2002 4:58 PM
Subject: [PHP] php mysql_num_rows problem
> Hi list,
>
> I have a class to perform my tasks to bd, among than there's this function
>
> function executa($sql="") {
> if($sql == "") {
> $this->resultado = 0;
> $this->numrows = 0;
> $this->row = -1;
> }
> $this->resultado = mysql_query($sql,$this->conexao->id);
> $this->numrows = mysql_num_rows($this->resultado);
> }
> everything works fine, except when I tri to insert a record. It inserts,
but
> give an error
>
> "Warning: Supplied argument is not a valid MySQL result resource in
>
/home/restricted/home/papagaiodigital/public_html/recrutamento/includes/clas
> sesql.inc on line 22"
>
> line 22 is "$this->numrows = mysql_num_rows($this->resultado);"
>
> what's the problem??
>
> Thank's n advance
>
> Rodrigo Peres
> --
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>