MySQL Forums
Forum List  »  General

platform independent alternative to group_concate, MYSQL < 4
Posted by: joseph curtis
Date: March 29, 2005 08:07AM

i am designing a car management module in php and most the servers hosting and especially the one i am one are still using MYSQL<4. Now the problem is that i have two tables:

CAR, CARDETAILS #join by carid (auto on car)

what i initially wanted to achieve would have been dealt with using the GROUP_CONCATE aggregate function, but this is not available on versions less than 4. Point being to build a string out of the car details, if you get what i mean

I have seen alternatives but none boast platform independence, nor any that i have found support the LINUX box i am hosting on....

does anyone have any other alternatives they can send my way

Options: ReplyQuote


Subject
Written By
Posted
platform independent alternative to group_concate, MYSQL < 4
March 29, 2005 08:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.