I use while loop
$i = 0;
$arr = array();
while($get_key1 = mysql_fetch_assoc($get_key))
{
$busid = $get_key1['busid'];
$get_key2 = mysql_query("select * from `route` where `busid`='$busid'") or die(mysql_error());
while($get_key3 = mysql_fetch_assoc($get_key2))
{
$arr[$i] = $get_key3['routid'];
echo "<pre>";
print_r($arr);
}
echo "<hr/>";
$i++;
}
This inner loop gives three values 1,3,4, and when it repeats again, it gives values 1,4I want to create a multidimensional array as
array(array(1,3,4),array(1,4))
but the above code gives the result as:
Array
(
[0] => 1
)
Array
(
[0] => 1
[1] => 3
)
Array
(
[0] => 1
[1] => 3
[2] => 4
)
Array
(
[0] => 1
[1] => 3
[2] => 4
[3] => 1
)
Array
(
[0] => 1
[1] => 3
[2] => 4
[3] => 1
[4] => 4
)
How to store values through a while loop in a multidimensional array
source
share