title: MySQL+PHP: Get group of photos of each single objects of other table
body: <p>Basically, I have two tables: <strong>objects</strong> and <strong>pictures</strong></p>
  
  <p>For each objects, users could upload some photos. (max 6)</p>
  
  <p>So... For each upload I save picture into table <strong>pictures</strong></p>
  
  <p>Example</p>
  
  <p><strong>Objects</strong>
  id=1, name=shoes, data_creation=1234</p>
  
  <p>and</p>
  
  <p><strong>Uploads</strong></p>
  
  <p>id=1, obj_id = 1, url=LINK1</p>
  
  <p>id=2, obj_id = 1, url=LINK2</p>
  
  <p>id=3, obj_id = 1, url=LINK3</p>
  
  <hr>
  
  <p>So, I need to select all that I need in one single query... Is it possible?</p>
  
  <p>The best thing would be merge photos like array... so the returing feching should be like this</p>
  
  <p>id=1, name=shoes, photos=[url1,url2,url3]</p>
  
  <p>or... even better</p>
  
  <p>id=1, name=shoes, photos=[{src=LINK1,caption=CAPTION1},{src=LINK2,caption=CAPTION2},{src=LINK3,caption=CAPTION3}]</p>
  
  <p>There's a way to do that in MySQL+Php?</p>
  
  <p>I tried with inner join/left join but this return object information for each picture found.</p>
  
  <p>Please help me... I'm going crazy :D</p>