arrays problem

pcwizzzz

Hi,
I have problems with writting a query into an array. I have
$row['countryID'] and $row['countryname'] and i need to put them into something like countries[0]['countryID'],countries[0]['countryname'],countries[1]['countryID'], countries[1]['countryname] ........
Here is my code and it doesn't work.

$sql="select * from tari";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
$countries[$i][$id_tara]=$row['id_tara'];
$countries[$i][$nume_tara]=$row['nume_tara'];

}
Someone could tell me what's wrong ?

cahva

How about:

$sql="select * from tari"; 
$result=mysql_query($sql); 
$i=0;
while($row=mysql_fetch_array($result)) 
{ 
$countries[$i]['id_tara']=$row['id_tara']; 
$countries[$i]['nume_tara']=$row['nume_tara']; 
$i++;
}

Weedpacket

$countries = array();
$count=mysql_num_rows($result);
for($i=0;$i<$count;$i++)
 $countries[]=mysql_fetch_array($result);

cahva

...and the better way 🙂

pcwizzzz

It doesn't work any of those two pieces of code. Doesn't write my info in countries arrays.

pcwizzzz

I'm sorry, was my mistake. It works, sorry again. The problem is with the loading options part. Here is the code, maybe you see what's wrong cause i dont. Helppppppppppp🙁.

$countCountries=count($countries);
$cmbCountries='<select name="id_tara" OnChange="this.form.submit()">';
$options=array();
$options[]='<option>Alegeti o tara</option>';
for($i=0;$i<countCountries;$i++)
{
$options[]="<option value=\"{$countries[$i]['id_tara']}\">{$countries[$i]['nume_tara']}</option>";
}
$cmbCountries.=implode('',$options).'</select>';
Thanks

pcwizzzz

It's ok , sorry for bugging you with my stupidity. I found the error......so childish. Thank you all for the help and sorry again for bugging with such stupid error. was a missing $, damn mistake and i didnt see it.
All the best.