Re: MySQL Result
| From: | Micah Stevens | Date: | Mon, 07 Mar 2005 02:18:48 +0000 |
| Subject: | Re: MySQL Result | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38787@lists.php.net to get a copy of this message | ||
Just reorder your list of selected fields.
SELECT <fieldnames in order to be returned> from <tablename> WHERE
<requirements>
-Micah
On Sunday 06 March 2005 01:10 pm, Wendell Frohwein wrote:
> Hello all,
>
> Have a question for you, don't know how simple this is. I want the
> output that mysql sends to arranged a certain way and I don't know if it
> is possible.
>
> Here is the select statement:
>
> SELECT cart_search.id, cart_search.year, cart_makes.thename as makename,
> cart_models.thename as modelname, cart_versions.thename as versionname
> FROM cart_search, cart_makes, cart_models, cart_versions WHERE
> cart_search.rand='PYYKjQFXRBa3PkYMpsnY' AND
> cart_makes.id=cart_search.make AND cart_models.id=cart_search.model AND
> cart_versions.id=cart_search.version ORDER BY cart_makes.thename,
> cart_models.thename, cart_search.year;
>
> cart_search.rand='PYYKjQFXRBa3PkYMpsnY' is what I use to call up a group
> to a specified product.
>
> Here is the output from above:
>
> +----+------+----------+-----------+-------------+
>
> | id | year | makename | modelname | versionname |
>
> +----+------+----------+-----------+-------------+
>
> | 9 | 1992 | Acura | Integra | RS |
> | 10 | 1993 | Acura | Integra | RS |
> | 1 | 1994 | Acura | Integra | GSR |
> | 2 | 1995 | Acura | Integra | GSR |
> | 3 | 1996 | Acura | Integra | GSR |
> | 4 | 1997 | Acura | Integra | GSR |
> | 5 | 1998 | Acura | Integra | GSR |
> | 6 | 1999 | Acura | Integra | GSR |
> | 7 | 2000 | Acura | Integra | GSR |
> | 8 | 2001 | Acura | Integra | GSR |
>
> +----+------+----------+-----------+-------------+
>
>
> I wanted to know if it would be possible for it to output it like so:
>
> +----------+-----------+-------------+----------------------+
>
> | makename | modelname | versionname | years |
>
> +----------+-----------+-------------+----------------------+
>
> | Acura | Integra | RS | 92,93 |
> | Acura | Integra | GSR | 94,95,96,97,98,99,01 |
>
> +----------+-----------+-------------+----------------------+
>
>
> Thank you all once again for your help.
>
>
> -Wendell Frohwein