select only one record

[Newsgroup_User]

I have a MySQL table with multiple records. Fields include:
id
title
text
imageName
imageOfWeek

I would like to set up a system that would allow my client to select one and
only one record (record of the week) to display on a web page. Then next
week select a different record of the week.

Now my question: Is there a simple way to ensure that last weeks record is
deselected at the same time this weeks record is selected?

Jeff

[Newsgroup_User]

I figured a method using a hidden form elements with a default value to
deselect the old record of the week before moving on to a new edit page to
select a new record of the week or adding additional records to the
database..

Jeff

"Jeff" <jeffs@NoSpamLamSam.com> wrote in message
news:g1jjal$q3o$1@forums.macromedia.com...
>I have a MySQL table with multiple records. Fields include:
> id
> title
> text
> imageName
> imageOfWeek
>
> I would like to set up a system that would allow my client to select one
> and only one record (record of the week) to display on a web page. Then
> next week select a different record of the week.
>
> Now my question: Is there a simple way to ensure that last weeks record is
> deselected at the same time this weeks record is selected?
>
> Jeff
>
>
>