wont finish rending rest of page after query loop

numerical25

i have code that grabs some data from a database and loops it out. but for some reason after its done looping. it wont finish rendering the rest of the page. it just stops and everything below it is blank . here is the code

 <?php 
			$con = new mysqli('localhost','root','$password','pimpmysite'); 
		$blogs = @$con->query('SELECT * FROM blog');
                $x = 0;
                while (($blogs = @$blogs->fetch_assoc()) != NULL){
                    echo "<a href='news.php?id=".$blogs['id']."'>".$blogs['subtitle']." ". $blogs['date']."</a><br/>";


            } 

        ?>

bretticus

Are you sure the entire loop is rendered?

Why don't you remove the error suppressing on the following lines:

$blogs = @$con->query('SELECT * FROM blog');
while (($blogs = @$blogs->fetch_assoc()) != NULL){

I suppose if "most" of the loop were being echoed out, we could eliminate the first line listed as the culprit.

By the way, when you look at the source, do you see an error message at the bottom of the page?

If not, are errors turned off (recommended for production servers?) You can check with a simple:

echo 'display_errors = ' . ini_get('display_errors') . "\n";

For more information about errors, see the manual.

If you have access to logs, check for an Apache error status codes (50*.)

numerical25

I figure out the issue. For some reason you cant take $blogs->fecth_assoc() and put it in a varible with the same name

$blogs = @$blogs->fetch_assoc()

where the varible blogs that is being assigned a value has to be another varible like $results or anything that is pretty much not $blogs

bretticus

Oh wow, I'm losing my troubleshooting eye! That should have been obvious.

For some reason you cant take $blogs->fecth_assoc() and put it in a varible with the same name

Because the first time you assign the array to the variable $blog, you have reassigned that variable from the MySQL resource value it previously had, and, consequently, what that variable needs to be in order to call fetch_assoc() and get the next row. So that means you got the first row and then an error on the next iteration of the while loop when it tried to call fetch_assoc() using an array instead of a mysql resource (except you were suppressing it with the @.)