内连接和回声解决方案

Question

I have an inner join of three tables:

    $result=mysql_query("SELECT singleimageupload.codrif AS codrif,
       singleimageupload.imagesname AS bigimage,
       uploads.imagesname AS multipleimage,
       uploads.description AS multipledescription,
       exposition.name,
       exposition.author,
       exposition.description,
       exposition.misure,
       exposition.date,
       exposition.status
  FROM exposition
 INNER JOIN singleimageupload ON singleimageupload.codrif = exposition.codrif
 INNER JOIN uploads ON uploads.codrif = exposition.codrif
 WHERE singleimageupload.firstimage = 'first' AND exposition.codrif = 'A002'
 ORDER BY exposition.codrif");

and I get this result:

I have, with this conditions, a result for each uploads path that I have.

My goal is to get something like this:

So, I would like to merge all uploads path for their Cod Rif (in this example, A002).

This is my full code:

  <?php



include('guestconfig/config.php');



$result=mysql_query("SELECT singleimageupload.codrif AS codrif,
       singleimageupload.imagesname AS bigimage,
       uploads.imagesname AS multipleimage,
       uploads.description AS multipledescription,
       exposition.name,
       exposition.author,
       exposition.description,
       exposition.misure,
       exposition.date,
       exposition.status
  FROM exposition
 INNER JOIN singleimageupload ON singleimageupload.codrif = exposition.codrif
 INNER JOIN uploads ON uploads.codrif = exposition.codrif
 WHERE singleimageupload.firstimage = 'first' AND exposition.codrif = 'A002'
 ORDER BY exposition.codrif");




while ($row = mysql_fetch_assoc($result)) {


?>
<table border="0">

<tr>
<td> <?php echo $row['codrif']?> </td>
</tr>
<tr>

<td> <?php echo $row['bigimage']?> </td>
</tr>
<tr>

<td> <?php echo $row['name']?> </td>
</tr>
<tr>

<td> <?php echo $row['author']?> </td>
</tr>
<tr>

<td> <?php echo $row['multipledescription']?> </td>

</tr>
<hr>
</table>

<?php } ?>

I don't know if I explained it clear, I hope so

Answer 1

try using group_concat(uploads.description) and group by singleimageupload.codrif