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
 

Reply via email to