MySQL Forums
Forum List  »  PHP

Re: serialise query?
Posted by: Roland Bouman
Date: August 18, 2005 03:10PM

Maik Kerner wrote:
> Is it possible to serialise results of query?

Yes, but you'd have to fetch the records yourself, store them in you favourite array or object and use

serialize()


> I want to get the client data with each entry in
> data seperated with a coma.
>
> Is this possible? Do you have an example?

This is another question. You can do that in a query:

select t1.clientid
,t1.name
,t1.Surname
,group_concat(t2.data) as data
from table1 t1
inner join table2 t2
on t1.clientid = t2.clientid
group by
t1.clientid
,t1.name
,t1.Surname

Options: ReplyQuote


Subject
Written By
Posted
August 17, 2005 11:13PM
Re: serialise query?
August 18, 2005 03:10PM


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.