only one row in the table can have a certain value

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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.

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

Quoted text here. Click to load it

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'

Site Timeline