Skip to main content
Inspiring
May 28, 2008
Question

select only one record

  • May 28, 2008
  • 1 reply
  • 209 views
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



This topic has been closed for replies.

1 reply

Inspiring
May 29, 2008
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
>
>
>