I am going to assume that you are using DataAssist to manage your database.
1st thing to do is to add another field to your database table (I call this archive but you can call it whatever you want) here is a sample of a typical table that I would use
CREATE TABLE `tbl_sample` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`description` text COMMENT 'Description - Max 65,535 Characters (String)',
`image` varchar(100) DEFAULT NULL COMMENT 'Image File - Max 100 Characters (Fixed Length)',
`sortorder` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Controls of order of appearance - higher number equals greater importance',
`archive` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Archive Option (removes this from display in the front end)',
`tstampinsert` int(11) unsigned DEFAULT NULL COMMENT 'insert a unix tstampinsert here using <?php echo time(); ?> in a hidden field in your form',
`tstampupdate` int(11) unsigned DEFAULT NULL COMMENT 'insert a unix tstampinsert here using <?php echo time(); ?> in a hidden field in your form',
PRIMARY KEY (`id`),
FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='This table stores the product options info (optional)' ;
You can then use the Data Assist Wizard to create the control pages or build them yourself is you wish.
On the public facing pages I add a where statement to my recordset that says only display a record if archive = 0 sample:
SELECT id, description, image FROM tbl_sample WHERE archive = 0 ORDER BY sortorder
This will display only records with an archive value of 0
Hope that gets you going.
