Re: [PHP] some data output formatting and grouping question...

2002-12-02 Thread Marek Kilimajer
you got the results, now loop it, and if you find Y is different from the previous one, print it: $previous=''; while($row=mysql_fetch_array($res) { if($row['Y']!=$previous) echo $row[Y]br; echo $row[X]br; } Victor wrote: I just have a fucking mental block; I cannot at all conceive the

[PHP] some data output formatting and grouping question...

2002-12-02 Thread Victor
I just have a mental block; I cannot at all conceive the necessary syntax to or even the theoretical algorithm that I need, to do the following: Consider the following table: U | X | Y --|---|-- me|001|0a me|002|0a me|003|0a me|002|0b me|003|0b me|004|0b ..|...|.. then the code says: SELECT *

[PHP] some data output formatting and grouping question...

2002-12-01 Thread Victor
I just have a fucking mental block; I cannot at all conceive the necessary syntax to or even the theoretical algorithm that I need, to do the following: Consider the following table: U | X | Y --|---|-- me|001|0a me|002|0a me|003|0a me|002|0b me|003|0b me|004|0b ..|...|.. then the code says: