Assign Query Result to Array

Hello there

i have a table with two field ID and CAPACITY

i want the ID to point to the capacity on an array

$top = "SELECT * from topics";

$db = new mysqli('localhost','root','323232');
$db -> select_db('testing');

$res_top = $db->query($top);
$topics = array();
while ($row = $res_top->fetch_row())
{
$topics[$row['id']] = $row['capacity'];

}

is this the right way?

thank you

not quite sure what you're after but that looks right.

well the tables has

ID CAPACITY
1 10
2 20
3 50
4
..
..
100

i want the array to be of format

$topics = array(id => capacity)

1 => 10
2 => 20

then yes, your code looks good. try running it and executing print_r($topics) at the end to see what's in the array to check it works.

mmm yes i did that and although it prints out this

Array ( [] => ) Array ( [] => )

there are no values in it....

are you fetching the rows from the db as associative arrays?
mysql-fetch-assoc
as opposed to a numerical array:
mysql-fetch-row

ok mate thx i ll look it🙂

hey mate...well because they are non-numerical arrays it works with assoc

as i showed u before....with the for loop

i have this now

while ($row_top = mysqli_fetch_assoc($res_top))
{
$countTop = count($topics);
$topics[$row_top['top_id']] = $row_top['max_stud'];

}
print_r($topics);

which prints the following:

[111] => 2
[112] => 3
[113] => 2
[114] => 3
[115] => 1
[116] => 3
[117] => 1
[118] => 1
[119] => 1

this is what i want.....
the strange thing is that when i do the following there is no print out
do u perphaps know why?

for ($j = 0; $j < $countTop; $j++)
{
if($topics[$j] != 0)
{
echo 'yes';
}
}

countTop is the counter of the array elements

is your array counter looping through from 0 to the number of items in the array? your array keys are not sequential so that will not work. try:

foreach ($myArray as $key=>$value) {
 if($key != 0)
{
echo 'yes';
}
}

ok mate i ve done it and it works now....well this is a hashtable because the [111] is a field of a database query