troubleshooting Question

query in php

Avatar of joyacv2
joyacv2Flag for Puerto Rico asked on
PHPMySQL Server
1 Comment1 Solution297 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros