php - MySQL 连接表列

Question

已关闭。此问题需要 debugging details 。目前不接受答案。

---

编辑问题以包含 desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem 。这将有助于其他人回答问题。

已关闭 7 年前。

Improve this question

我对此非常陌生，我需要一些帮助。

    <?php
        $query = "SELECT owners_dogs.dog_id, dog.name, FROM owners_dogs 
        LEFT JOIN dog ON owners_dogs.dog_id = dog.id WHERE owners_dogs.person_id=$currId ORDER BY dog.name;";
        $result = mysql_query($query) or die('Query failed: ' . mysql_error());
        if (mysql_num_rows($result)>0) {    
            echo "<i>Owner of: </i>";
            echo "<div style='padding-left:25px;padding-bottom:10px;'>";
            while ($line = mysql_fetch_object($result)) {
                echo "<a href='details.php?id=$line->dog_id'>";
                echo "$line->name </a><? if(dog.certfied == '1') echo "CP" ?><br>";
            }
            echo "</div>";
        }
    ?>

我遗漏了一些东西......我试图让脚本在dog.certified = 1时回显一些文本

任何帮助将不胜感激

Answer 1

我发现两个可能的错误
1. 要使用certfied 的值进行比较，您应该首先在查询中获取该数据。
2. 并且在while循环中不能直接使用dog.certfied，而是使用$line->certfied。

试试这个

$query = "SELECT owners_dogs.dog_id, dog.name, dog.certfied, FROM owners_dogs
    LEFT JOIN dog ON owners_dogs.dog_id = dog.id WHERE owners_dogs.person_id=$currId ORDER BY dog.name;";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
if (mysql_num_rows($result) >0 )
{
    echo "<i>Owner of: </i>";
    echo "<div style='padding-left:25px;padding-bottom:10px;'>";
    while ($line = mysql_fetch_object($result))
    {
        $dog_id = $line->dog_id;
        $name = $line->name;


        echo "<a href='details.php?id=".$dog_id."'>";
        echo $name."</a>";
        if($line->certfied == '1');
        {
            echo "CP"."<br>";
        }

    }
    echo "</div>";
}