Yo, I've got a question on how to return ID's of deleted rows.

solace_d_

I'm also new to the forums. 😃

Anyway, I've been trying to find a simple solution for this. I've been told it can be done with one query.

I have a query that looks exactly like this:

$DB_site->query("DELETE FROM categories WHERE FIND_IN_SET('$catid',parentlist)>0" );

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 [font=courier]auto_increment 'categoryid'[/font] of the table [font=courier]categories[/font].

I need this for a later query that looks like this:

$DB_site->query("DELETE FROM images WHERE categoryid IN ($deletelist)" );

[font=courier]$deletelist[/font] being the rows deleted in the first query, arranged in a comma seperated list using implode().
I would have great gratitude toward anyone who can help me with this problem. 😉

As you might have noticed by the $DB_site class, I'm using this in vBulletin.

juschillinnow

just out of curiosity.... is $catid the id for the row? can't you just use that?

solace_d_

$catid is the parent category id. I'm deleting the parent category, as well all its "sibling" categories.

That's easy to do, and is done in the first query.

Problem is, I need to delete all the images of the $catid, which is easy to do, but I also need to delete all the images of those sibling categories.

$catid is only one category id, I need to return the categoryid's of all the deleted categories from the first query, so I can use them in the second. 😃

I just don't know how 🙁

Weedpacket

Originally posted by solace d.
$catid is only one category id, I need to return the categoryid's of all the deleted categories from the first query, so I can use them in the second. 😃

I just don't know how 🙁

There might be some trick to do it, but you could just do a select id query with the same conditions that your delete query uses - do that first and it will tell you which id's are about to be deleted.

solace_d_

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 fashion.

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).
shrugs

Thanks though 😉

seby

you can use mysql_affected_rows(); by INSERT, UPDATE or DELETE queries.

Weedpacket

Originally posted by seby
you can use mysql_affected_rows(); by INSERT, UPDATE or DELETE queries.

Except that this would only say how many rows were deleted, not which rows they were.