Hello,

i've to build a SQL Statement from a table with the following resultset

table with rows

id      subid           roleid  rolebundle              name
50      0               0               50.0.0          header1
50      1               0               50.1.0          subheader1
50      2               0               50.2.0          subheader2
50      3               0               50.3.0          subheader3
50      3               1               50.3.1          subheader3.1
50      3               2               50.3.2          subheader3.2
50      4               0               50.4.0          subheader4
50      4               1               50.4.1          subheader4.1
50      4               2               50.4.2          subheader4.2

9 rows

SQL statement ???

Resultset

id      subid           roleid  rolebundle              name

50      1               0               50.1.0          subheader1
50      2               0               50.2.0          subheader2

50      3               1               50.3.1          subheader3.1
50      3               2               50.3.2          subheader3.2

50      4               1               50.4.1          subheader4.1
50      4               2               50.4.2          subheader4.2

6 Rows

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to