Mysql connection error

Question

I’m using this code:

<php?
$sql = mysql_query("SELECT `id`, `detail`, `time` FROM `news` ORDER BY `time` DESC LIMIT 5");
$return = mysql_fetch_assoc($sql); 
while($row = $return) { ?> 
    Data: <?php echo date("d/m/Y", $row['time']); ?> | 
    Noticia: <?php echo $row['detail']; } ?>

And when I run this code, the page keeps loading and does not return the database information.

Database:

The connection to the database is on another page, I used the require(); to pick up the connection.

Connection:

<?php error_reporting(0); $mysql = mysql_connect('localhost', 'root', ''); mysql_select_db('central');

And the page just loads and returns nothing.

Thank you so much!

Answer 1

The problem is in the following 2 lines:

//...
$return = mysql_fetch_assoc($sql); 
while($row = $return) { ?> 
//...

The function mysql_fetch_assoc must be within the while, that is, like:

while($row = mysql_fetch_assoc($sql))

That’s because the function mysql_fetch_assoc returns an associative matrix that corresponds to the obtained line and moves the internal pointer of the data to the next line.

For example, if your query returns 10 lines, the function mysql_fetch_assoc will get the data from the first line, change the internal pointer to the second line and so the cycle runs 10 times until at 11th the result is false, since there are no more lines.

When there are no more lines, the function returns false interrupting the cycle while.

Answer 2

I don’t know PHP, but I believe the method mysql_fetch_assoc($sql); must exist within the while() { }, so it will load a new row every turn in while.

Try something like that:

while($row = mysql_fetch_assoc($sql)) { }