Is it possible to delete data from webpage but do not delete from database?

[tohobaby]

Hi,

 

I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there?

 

Thank you.

[Frank_b]

Just add a column with a name like 'deleted' and set a 1 if a user deletes the record instead of really deleting the record. Then change yr select queries, you will need to add a

 

WHERE deleted != 1

 

And ready.

[ginerjm]

Are you just saying that you want the user to be able to filter what data shows up on the page?  For ex. you do a query and show him 10 records.  Then he clicks on a couple of rows on the screen because he didn't want them and you have to re-build the page leaving those two off?  Simply do as Frank said - change your query to exclude those two records by their key value and re-run the query.