SQL Insert and Delete?

Is there a way to grab and remove

[briesm]

Anyone know if there's a way to call a query but remove whatever you grabbed from the database, or would I have to do a query to retrieve what i needed, then follow it up with a delete on the same query results?

[Sarah Atkinson]

Do you mean something like: ?
$sql="DELETE FROM yourtable WHERE id='$id'";

[jatar_k]

>> do a query to retrieve what i needed, then follow it up with a delete on the same query results

yes, that would be the way to do it