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
