无法显示相同ID的所有行 - PHP

Question

H, previously i messed around with my scripts on pagination. Then my entire script went crazy. Now, i removed all the scripts relating to pagination, and all of a sudden, now I cannot display all rows of same id. For example. for id 99, i have 9 rows of same id in sql. But it only displays 5 rows. Please help Thanks.

  $query="SELECT ua.* FROM useradvert ua INNER JOIN users u ON  ua.id =u.id
     WHERE ua.id='".$id."'";



$stmt = $conn->prepare($query); 
$stmt->execute();
$res2 = $stmt->get_result(); 
$row2 = $res2->fetch_array();


$_SESSION['name2'] = $row2['name2'];
$_SESSION['color2'] = $row2['color2'];
$_SESSION['hobby2'] = $row2['hobby2'];
$_SESSION['radiobtn'] = $row2['radiobtn'];
$_SESSION['kupon'] = $row2['kupon'];
$_SESSION['image'] = $row2['image'];
$_SESSION['image2'] = $row2['image2'];

Continue below..on same page

while ($row2 = $res2->fetch_array(MYSQLI_ASSOC)){

echo "<li>".$_SESSION['name2'] = $row2['name2']."</li>";
    echo "<li>".$_SESSION['color2'] = $row2['color2']."</li>";
    echo "<li>".$_SESSION['hobby2'] = $row2['hobby2']."</li>";
    echo "<li>".$_SESSION['radiobtn'] = $row2['radiobtn']."</li>";
    echo "<li>".$_SESSION['kupon'] = $row2['kupon']."</li>";
    echo  "<li>".$_SESSION['image'] = $row2['image']."</li>";
    echo "<li>".$_SESSION['image2'] = $row2['image2']."</li>";}

Answer 1

Looks like your sql query might be causing the problem, try removing the Double quotes

$query="SELECT ua.* FROM useradvert ua INNER JOIN users u ON ua.id =u.id WHERE ua.id='".$id."'";

TO

$query="SELECT ua.* FROM useradvert ua INNER JOIN users u ON ua.id =u.id WHERE ua.id='.$id.'";