dtqu72830 2017-04-04 11:56
浏览 27
已采纳

内连接和回声解决方案

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: enter image description here

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

My goal is to get something like this: enter image description here

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

  • 写回答

1条回答 默认 最新

  • dongxiz5342 2017-04-04 12:08
    关注

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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择
  • ¥15 这款软件是什么?需要能满足我的需求
  • ¥15 SpringSecurityOauth2登陆前后request不一致
  • ¥15 禅道二次开发编辑版本,上传不了发行包
  • ¥30 arcgis处理夜间灯光数据,使用投影栅格使图像变暗