ummm...it's not clear at all what your decisioning criteria are. That is to
say, how did you come up with the 6 rows in your result set? Are they
chosen randomly or is there some rhyme/reason to how you chose them? (and
if it's the latter -- what is your rhyme/reasoning?)
----- Original Message -----
From: "ckieninger" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 07, 2001 4:47 AM
Subject: [PHP] How to build this SQL statement?
> 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]
>
>
--
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]
