mysql: last_updated_id

[Bob Bedford]

Does it exits a mysql or PHP function to know the last updated id record ?
When you perform an insert you can know the last inserted ID. In my case I'd
like the same with the last updated. I'm trying to avoid to do a new query.

It's there any possibility ?

Bob

[Chris Hope]

Bob Bedford wrote:

Does it exits a mysql or PHP function to know the last updated id
record ? When you perform an insert you can know the last inserted ID.
In my case I'd like the same with the last updated. I'm trying to
avoid to do a new query.

mysql: select last_insert_id()
php: mysql_insert_id() http://www.php.net/mysql_insert_id

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Chris Hope]

Chris Hope wrote:

Bob Bedford wrote:

Does it exits a mysql or PHP function to know the last updated id
record ? When you perform an insert you can know the last inserted
ID. In my case I'd like the same with the last updated. I'm trying to
avoid to do a new query.

mysql: select last_insert_id()
php: mysql_insert_id() http://www.php.net/mysql_insert_id

Now I realise I didn't read your post correctly and answered your
question wrong :)

If you just updated a record then surely you know the id of the record
you updated already? ie in the query "update sometable set somecolumn =
somevalue where keyfield = anothervalue" then the updated id is
'anothervalue'

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[Bob Bedford]

> If you just updated a record then surely you know the id of the record

you updated already? ie in the query "update sometable set somecolumn =
somevalue where keyfield = anothervalue" then the updated id is
'anothervalue'

Hem..sounds you are kidding, but:

update sometable set somecolumn = somevalue where idarticle = 1500 and
lastdate > now()

sometable.
idrecord, idarticle,lastdate....

I don't know the idrecord when updating.