[Resolved] MySQL Affected Rows

[rcoursey]

Code:

$result = dbquery("UPDATE faq SET faqnum='$faqnum', faqques='$faqques', faqans='$faqans' WHERE faqid='$id'");
$num_rows=mysql_affected_rows();
echo $num_rows;

I am trying to use the mysql_affected_rows to determine how many records were updated.

I am getting updates to the DB but the echo $num_rows is '0'. It should be at least 1.

[YappyDog]

What does your dbquery function do?

[rcoursey]

The dbquery() handles login, database selection, and processes the query passed by the function. The function works well.

OOps, just had a thought... it is possible it does not work because the connection and query takes place in the function? If so I'm feeling that "dumb" feeling.
🙂

[tsinka]

MySQL doesn't do anything if your update wouldn't change anything (e.g. all field values in you update match the ones already stored in that row).

mysql_affected_rows will then return 0.

[YappyDog]

Could also be a problem if the dbquery() function issues a COMMIT before returning.

[rcoursey]

reply to tsinka:

Data is being changed.

[kevinsequeira]

put this

$num_rows=mysql_affected_rows();
return $num_rows;

inside the function dbquery();

and
echo $result;

OR

are you returning anything from the function ???

post the code for dbquery()

reg
kevin

[ahundiak]

You said that dbquery "handles login, database selection, and processes the query". I am wondering if it closes the connection when it finishes.

[tsinka]

Hi,

AFAIK php automatically closes the connection when a script has been parsed (of course not if you use mysql_pconnect).

[rcoursey]

Thanks to all!

I've accepted the function does not work in the main program due the the function. The function returns $result.

Since mysql_affected_rows occurs outside the function it would have no idea of what occured. I will ammend the function to obtain and return the affected rows. This should solve my problem.

If not I'll get back.