MySQL LEFT JOIN 显示重复行 [英] MySQL LEFT JOIN display duplicate rows

问题描述

我在使用 MySQL 左连接时遇到问题，它返回同名的重复行.

I'm having an issue with an MySQL left join it returns duplicate rows for the same name.

            $result = mysql_query("SELECT
            w.id AS 'WheelID',
            w.name AS 'Name',
            i.id AS 'ImageID',
            i.image_url AS 'Image'
            FROM `rims` AS w
            LEFT JOIN `rims_images` AS i ON
            (w.`id` = i.`mid`)
            WHERE w.`id` =  '".$model."'

           ");
              while($row = mysql_fetch_array($result))
            {

                   echo $row['Name'];
                echo $row['Image'];

            }

谢谢您的帮助，我们将不胜感激.

Thank you any help will gladly be appreciated.

推荐答案

仅在循环中显示 Name 一次:

Only display the Name once in the loop:

$first = true;
while ($row = mysql_fetch_assoc($result)) {
    if ($first) {
        echo $row['Name'];
        $first = false;
    }
    echo $row['Image'];
}

这篇关于MySQL LEFT JOIN 显示重复行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！