Highlighting a DB record

I need to be able to.....

[Smad]

Hi all... Happy New Year

I am making a CMS for someone who sells boats.

On the front of the site there will be a "boat of the week"

I am having problems trying to implement a system where the customer can select a single boat from the DB using an admin interface. I presume a radio button of some sort next to each record.

A: How should this been included in the DB ie. field?
B: How do I make sure any previous selections are removed when the new is selected?

Thanks for any help

[dcrombie]

Create a new db table: featureboat (id int);

Create a SELECT list where they select a boat and submit.

If you INSERT a single record manually then you can use UPDATE on that table and never have to worry about DELETE/INSERT.

;)

[Smad]

thanks dcrombie...