delete id?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

delete id?

Post by shiznatix »

i know there is a mysql_insert_id but is there somthing that does the same thing as insert_id but with a delete query? like a mysql_delete_id.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

you just want to find out the ids of the rows it deleted? I'm pretty sure there's not a function that can tell you this...you could write one pretty easily though, just pass the where clause as an argument and then select against it, throw the id's into an array, then delete the rows and return the array...
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

good thinking detective, i shall report back when i have finished my questioning of the suspects and tell you wether or not they can be charged with the known crime.
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

tried and guilty, they were sentenced to death earlier today and were hung then emidiatly shot then burned...all at sundown
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

nice :D
Post Reply