Can i retrive different fields of a record as one result.

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,555 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,783 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Can i retrive different fields of a record as one result.

•

Join Date: Feb 2008

Location: Cochin

Posts: 67

Reputation: jino is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

jino

Offline

Junior Poster in Training

Can i retrive different fields of a record as one result.

Apr 12th, 2008

Dear All,

I am new to MySQL. Can i retrive the result of a query as the combination of different fields of a single record..

For example..
if the result record of a query is ... id(1), country(India), Location1(maharashtra), Location2(pune), Location3(Navi Mumbai)...

My doubt is that can i retrive the 3 locations as one field..

Please excuse me if this is a foolish question..

Regards,

Jino..

We only have to do a very few things right in our life, so long as we don't do too many things wrong.