Re: I'm not getting all my records

[Irvin Amoraal]

It took a while, but I figured out what you saw, that I used the same command twice. So I took the first one out, and replaced the second with a "mysqli_fetch_array". It's working properly now.
Thanks.
Irvin.

// blogID, blogTitle, blogAuthor, blogImg , blogDate, blogText
$SQL = "SELECT blogID,blogTitle from blog ORDER BY blogID DESC LIMIT 5 ";
$RESULT2 = mysqli_query($conn,$SQL) or die (mysqli_error());
$row_cnt = mysqli_num_rows($RESULT2);
if($row_cnt>0){
    echo"<h3>".$row_cnt." Recent Postings</h3>";
    while ($row = mysqli_fetch_array($RESULT2)){
        echo('<br><a href="blog.php?ID='.$row[0].'">View</a>&nbsp;&nbsp;'.$row[1]);
    }
}

if($row_cnt>5){
    echo'<br><a class="readmore" href="#">more...</a><br>';
}

mysqli_free_result($RESULT2);

?>