Re: column_name

> I was wondering if there was a way to retreive a column_name instead of a > value in a query? > > For example if my table has the field firstname, lastname, telephone, > movie1, movie2, movie3...... > > > And my first record is John Doe 555-5555 > good bad bad > My second record is Jane Doe 555-6666 good > good bad > > I would like to know which movies Jane Doe rated "good"'...............Is > this possible and if so how? http://php.net/mysql Look for something like "get_field_names" or somesuch. This is probably not the best design for doing Movie Reviews, so hopefully that was just an example... -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm