Returning the ID's of deleted rows?
 

I have a query that looks exactly like this:
I need to somehow return the ID's of the rows deleted from this query. Those ID's being the values of the first column auto_increment 'categoryid' of the table categories.

I need this for a later query that looks like this:
$deletelist being the rows deleted in the first query, arranged in a comma seperated list using implode().

I would be very thankful if you could help. ;)

hmm i don't know if this is dooable but you can do a workaround with a query you have to run before the delete query

SELECT id FROM...
then
DELETE from cat
then
Delete from images..

True, that way wouldn't be hard, and I was about to result to that, but I was just seeing if it could be done in some other simpler trick.

Too bad it can't be done with something simple like how you can return the auto_increment id of an INSERT command using $DB_site->insert_id();

PHP needs a delete_ids(); that functions like insert_id(); but for the DELETE query (and can return many values).
[high]* Velocd shrugs
[/high]

Thanks though ;)

Such a function is a nice idea in concept but doesn't apply: insert_id() returns the newly created id of an auto_increment column. Nothing new is generated so nothing can be retrieved.