代码没有';t work-mysql获取维度数组


The code doesn't work - mysql fetch dimesional array

当我执行下一个代码时,它会运行,但不会显示图片。它允许吗选择列?如代码所示:

$query = "SELECT ID AND nickname FROM tbl_photo";

非常感谢!

while($photoID = mysqli_fetch_array($result))
{
    echo '<a href=img/'.$photoID[$i].'.php><img src="uploads/'.$photoID[$i].'.jpg" alt="Picture" class="photo" width="800" height="600"/></a>התמונה הועלתה על ידי '.$photoID[$i][$j].'
            <form action="like.php" method="POST" ><input type="image" src="img/like.jpg" width="20" height="20"  name="submit" value="'.$photoID[$i].'"/></form>';
}

您应该使用comma而不是and,如下所示

$query = "SELECT ID , nickname FROM tbl_photo";