How to auto delete table row?

[just me and php]

Hi

Im Not Real Good At Explaining What I Want So Please Bare With Me.

 

I Have A Page On My Site That The Database Outputs To.

There Is A User That I Dont Want To Ban Yet , But I Do Want To Block Or auto Delete His Data.

Now When Everyone Post New Data The Only Table That Would identify Them Is The Username Table, There Is No Member ID Table.

Now I Would Like To querry The Database And Auto Delete Table (Username) BOBBY And The Row BOBBY Posted , So There Is No Data Output To My Site Page For BOBBY.

 

Can Someone Give Me A Couple Codes To Try, And I Would Think The Code Would Need To Be On A New Page That I Need To Make Up Right?

 

Thanks

[teng84]

your explanation is very bad but ill try this

SELECT * FROM YOURTABLE WHERE FIELDS NOT IN('BOB','ASTIG')

That retuns data without bob and astig

 

now on your auto delete or ban!!!! i should say use another field for that

that will be set as active and non active

[just me and php]

Thanks Il Try That

[suma237]

click on "Topic solved"

[teng84]

hmm how can we tell this people to do that allot of topic are being solve but they dont mark it solve  ???