PHP Double While Loops

<?php require_once(‘dbconnect.inc’);
$db=dbconnect();
$start = microtime(true);

$command= ‘SELECT id FROM table_sort ‘;
$result = mysqli_query($db, $command);

while($row = mysqli_fetch_assoc($result)) {
$id = $row[‘id’];

$command2= “SELECT url FROM members_urls WHERE member_id=’$id’ “;
$result2 = mysqli_query($db, $command2);
while($row = mysqli_fetch_assoc($result2)) {
$url = $row[‘url’];
echo $url.'<br/>’;
}

}

Example #2

This example shows how an array can be made with the second while loop. Then, the array is pulled outside the loop and individual values are printed.

<?php require_once(‘dbconnect.inc’);
$db= dbconnect();
$start = microtime(true);

$command= ‘SELECT id FROM table_sort ‘;
$result = mysqli_query($db, $command);

while($row = mysqli_fetch_assoc($result)) {
$id = $row[‘id’];

$command2= “SELECT url FROM members_urls WHERE member_id=’$id’ “;
$result2 = mysqli_query($db, $command2);
while($row = mysqli_fetch_assoc($result2)) {
$url = $row[‘url’];
$url_array[] = $url;

}
}

$url_array = array_unique($url_array);
//print_r($url_array);

foreach($url_array as $item) {
echo $item.'<br/>’;
}