Give user mysql delete privilege for one query via php is this possible?

[c_shelswell]

Most of the question's in the title  . What i'm basically looking to do is give a user delete privileges for one query only. This is just so i can keep my database clean. Am i best just writing a DB logon script for that one query only and allowing that user to delete the records or is there a way PHP can grant delete for one query?

 

Cheers

[hackerkts]

I think more informations would be better, you can try to check their usergroup level and allow them to delete the query.

[c_shelswell]

The problem is every user must be able to delete. It's part of an online download centre. When a user reaches a certain point in the sale the code adds their purchases to a "purchases_pending" table they are then taken away to paypal. Paypal should then send back a confirmation of payment at which point the code adds their purchase to a "confirmed_purchases" table and to tidy up deletes the one in "purchases_pending"

 

It's this action that i need to solve.

 

Cheers