only one row in the table can have a certain value

[chris_huh]

I have a mysql database with a 'feeds' table in it allowing the use to
add feeds to their site. What i also want is for them to be able to
choose one to show on the homepage (or none), but only one. Is this
possible by having a field in the table called 'homepage' which is set
to 'no' for all but one (at the most). They would then be able to
choose which one to show by a list of all the feeds being generated
and they can select a radio button for that feed.

The only other way i can think of is to have another table with one
row in it which JOINS to the other one, but that may be getting more
messy if they is a simple way with one table.

[delishus]

Re: only one row in the table can have a certain value

On Mar 23, 6:16 pm, "chris_huh" <chris....@gmai l.comwrote:

I have a mysql database with a 'feeds' table in it allowing the use to
add feeds to their site. What i also want is for them to be able to
choose one to show on the homepage (or none), but only one. Is this
possible by having a field in the table called 'homepage' which is set
to 'no' for all but one (at the most). They would then be able to
choose which one to show by a list of all the feeds being generated
and they can select a radio button for that feed.
>
The only other way i can think of is to have another table with one
row in it which JOINS to the other one, but that may be getting more
messy if they is a simple way with one table.

Assuming I understand what your are after....I'd add another field to
your 'user' table where you store your user information like username,
password etc called feed_id. Whichever feed they select from the radio
button add it to feed_id. Then when you query out your user
information you'll know which feed to pull for them from the 'feeds'
table.