View Single Post

  #1 (permalink)  
Old 03-24-2007
chris_huh
 
Posts: n/a
Default only one row in the table can have a certain value

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.

Reply With Quote