Re: crosstab (was "Re: [PHP-DB] Using two colomns ...")

Chris, et al -- ..and then Chris Boget said... % [quoting Cpt John Holmes] % > From: "Chris Boget" <chris@wild.net> % > > If MySQL had crosstab functionality, that *might* be able to help. % > A "crosstab" is just a specifically formatted query, of which MySQL is % > certainly capable of handling. I've done them in the past, but maybe you're .. % % Then I'm not calling it the right thing... just the name of the type of query that % was told. The kind of query I'm talking about is the one that rotates the result % set from tall to wide. Basically doing exactly what the OP had asked for.. If Hmmm... You mean like taking results 1 a 2 b 3 c 4 d and changing it to 1 2 3 4 a b c d or such? I'm certainly confused. TIA & HAND :-D -- David T-G * There is too much animal courage in (play) davidtg@justpickone.org * society and not sufficient moral courage. (work) davidtgwork@justpickone.org -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!