Re: How to build this SQL statement?
| From: | Kurt Lieber | Date: | Sat, 07 Jul 2001 15:00:49 +0000 |
| Subject: | Re: How to build this SQL statement? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56638@lists.php.net to get a copy of this message | ||
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" <ckieninger@packdata.net>
To: <php-general@lists.php.net>
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: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>