hi, hope all be fine

i need to ask about how to make a user inactive instead of deleting it from the database
i.e: i need it to be hidden for the viewer when he use my web application but in fact it exists in my database.
using php code

how could i do this?

thanks in advance

I don't think you can.

Why not just create a copy of the structure and then add back the users.

i don't understand

if i can't do that

so if i can make the data hidden for the viewer of the web application and not deleted from the database ?

I don't think I understand the issue here. Could you please explain more in detail what you want to do.

Are you using Cookie Password Protection or is this a general database problem?

here is the issue

i need to make the viewer to my web application when he press on a button to make some users in my database in active or hidden to him but without deleting them from my database

i added an attribute to a table in my database which has the status of the user

0>>> inactive

1>>> active

but there is something wrong it doesn''t change the status in the database

here is the code

Is $Patient_id submitted via a form or something because if it is you may have to change it to $_REQUEST[Patient_id] to have it working.