Display cell from dynamic row selection

[Bovaum]

Hello,

I am attempting to search a MySQL table for a row using where statements to find unique pair of cells,

this I have been able to do using WHERE statements, however I then need to display the contents of a 3rd column from the same row and have been unable to figure out how to get this to function properly...

any help would be greatly appreciated

thanks

Alvin Mites

[Pig]

So are you saying you want to get the data from a certain column, where 2 of the other columns have specific values?

SELECT col1 FROM table WHERE col2=$foo AND col2=$bar