close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Show or Hide Repeating Regions-Records Toggle

Thread began 9/27/2009 12:59 am by troyd | Last modified 9/29/2009 1:30 pm by troyd | 1906 views | 9 replies

Dave BuchholzBeta Tester

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',
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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...