We help IT Professionals succeed at work.

query in php

joyacv2
joyacv2 asked
on
295 Views
Last Modified: 2014-08-05
I have the following table

name    zone   site    location
rt              2         5         street1
rt              5         8         street29
ty              3         9         street3i
vt              1          1        street4
vt               5         1        street10

i want something like that
name    zone   site    location
rt              2,5         5,8         street1,street29
ty              3         9         street3i
vt              1,5          1,1        street4,street10

i am using php and mysql, how i can do a query from table 1 to produce the table2 ? Any idea?
Comment
Watch Question

CERTIFIED EXPERT
Expert of the Year 2014
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.