I understand that PHP and MySQL work together. The point of my title is where is the best place to implement what I'm trying to accomplish. Is there some sql command that I'm missing that will accomplish what I want, or do I "need" to use PHP to format the output?

That's the point of the title. I'm going to experiment with if/else in PHP unless someone has a better suggestion.

Thanks,

DaK