How to echo full list of rows in php mysql using while loops but outside the loop

Question

Hello please help me is this code this code only show me last row of loop not full.

$sql = mysql_query("SELECT hash FROM users");
while($row=mysql_fetch_assoc($sql)) {
    $url = $row["hash"]."<br />";

}

5b50373f0dbd8ab7fe888060257967f2e0adcbdb

but full list is:

a065e7094234b1c836f9829ca9185a36132ff76f 5b50373f0dbd8ab7fe888060257967f2e0adcbdb

pleas help me

Answer 1

You can accomplish this one of three ways. Currently you are resetting $url on every iteration.

$sql = mysql_query("SELECT hash FROM users");
$url = '';
while($row=mysql_fetch_assoc($sql)) {
    $url .= $row["hash"] . "<br />";

}

or

$sql = mysql_query("SELECT hash FROM users");
$url = '';
while($row=mysql_fetch_assoc($sql)) {
    echo $row["hash"] . "<br />";

}

or

$sql = mysql_query("SELECT hash FROM users");
while($row=mysql_fetch_assoc($sql)) {
    $url[] = $row["hash"] . "<br />";
}

With this approach you need to iterate through the array later, foreach..

Answer 2

This is a good use case for foreach:

<?php
$sql = mysql_query("SELECT hash FROM users");
$rows = mysql_fetch_assoc($sql);
foreach ($rows as $row) {
    $url = $row["hash"]."<br />";
}
?>

Plus, you're overwriting the $url variable each iteration. Either push each value onto an array, or concatenate a string:

<?php
// ...
$urls = '';
$url_list = array();
foreach ($rows as $row) {
    $urls .= $row['hash'].'<br>'; // concatenation
    $url_list[] = $row['hash']; // add each URL to an array
}
?>

Then you can either output the final string, or iterate over the array when you want to recall the values.