Rows affected?

Roger Godefroy

Hi,

I am executing an update-query. Is there a way I would get a result if there
is a row affected, because if the row isn't affected (product may not exist)
I have to execute a insert-query. This way I could use 1 query (in the
update-case). Else I would always have to execute 2 query's (1 count-query
and 1 insert or update query).

Thnxz...

Jul 16 '05 #1

Andreas Paasch

no spam wrote:

Hi,

I am executing an update-query. Is there a way I would get a result if
there is a row affected, because if the row isn't affected (product may
not exist) I have to execute a insert-query. This way I could use 1 query
(in the update-case). Else I would always have to execute 2 query's (1
count-query and 1 insert or update query).

Thnxz...

http://dk.php.net/manual/en/function...ected-rows.php

Should give you a hint.
That it says dk.php.net is only due to the local mirror.

/Andreas
--
Registeret Linux user #292411

Jul 16 '05 #2

Roger Godefroy

thnxz... mysql_affected_rows() was the function. Totally forgot the
mysql-functions...

"Eivind Lie Nitter" <el*@gmx.net> schreef in bericht
news:1fz4bvf.ick75z156nw93N%el*@gmx.net...

Roger Godefroy <godefroy@(nospam)home.nl> wrote:

Hi,

I am executing an update-query. Is there a way I would get a result if there is a row affected, because if the row isn't affected (product may not exist) I have to execute a insert-query. This way I could use 1 query (in the
update-case). Else I would always have to execute 2 query's (1 count-query and 1 insert or update query).

Thnxz...

If you are using MySQL:

mysql_query("update table set bla='bla' where id=17");

if (mysql_affected_rows() == 0) {

mysql_query("insert ...");

}

Should work :)

--
Eivind Lie Nitter
el*@gmx.net
http://ununique.net

Jul 16 '05 #3