Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete records at once

Status
Not open for further replies.

TanTrazz

Programmer
Aug 18, 2001
54
NL
Hi all,

My email form is used for spamming. I've fixed it but the values filled in are all stored in a database...

All the fields are filled in with the same values. How can i delete them all at once. The server has an old version of phpMyAdmin so i cant check them all...

does someone have a script for deleting records with same field values??

TnQ TanTrazz
 
Just run an appropriate DELETE sentence in phpMyAdmin. Something like:
Code:
DELETE FROM tblName WHERE condition = "whatever the spammers value is";
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top