Posted by manny on 01/12/06 14:28

I wish I knew what this was called, and I could have made a more sensible
subject. For that matter, I knew what it was called, I could have googled it!

Anyway, let's I have a table with name, class, grade.

joe bio a
jill chem b
john psych b
john chem a
jill pysch a

and I want to display the results as

name bio psych chem
joe a - -
jill - a b
john - b a

Is there a way to do this with sql? How about sql with php?

Thanks much!

Manny
--
manny@don't spam on me

• Next in forum: Re: How do I do this query?
• Prev in forum: Re: html textarea --> php mail function produces additional line break
• Thread view: How do I do this query?

[Reply to this message]