Not sure how to ask- Multiple SELECT
by John Kincaid, November 5, 2007 20:33
I have a database of properties that has about 20 columns of features such as Fireplace, CaTV, Washer/Dryer that I want to output only those features that equal 1 or yes depending on if that property has that amenity.
For instance, I am SELECTing a row such as:
SELECT FP,WD,CATV or *)FROM Features WHERE pid=$pid$ not sure what else to use here
The results I want are to output "only" those column names that are equal to "1". One means the property has a fireplace, etc. If the property has "no Fireplace, then don't output
Kind of stumped here.
Name E-mail optional TopicMessage:
HTTP Link: Link text: