how can I hide a news entry ?

I am working on an CMS, and now I am creating a newsscript, it schould delete news entries , edit and hide news entries!
can somebody tell me how can I hide news entries!
the news entry should not be deleted from the database but the users schould not be able to see it on the webside page!
that means me as administrator , if I click on hide, this entry schould not be shown any more?
does somebody know which mysql command can do this ?
thanks
johni

 

Why don't you create a new column in the database to specify if the news is to be shown or not?

 

thanks for your reply
how can I manage this, it can be managed with enum ?
could you tell me please how can I do it ?
I am an amateur in php !
thanks
johni

 

You can do this many ways.
- enum column type like you said
- a tinyint(1) column (1->true; 0->false)
- a varchar(5) with values such as true or false.
- ...