[Resolved] naming an array

flientje

I want to make arrays of values in a table of my database..

like this:
i've got a table city and a table location in my db, now I'd like to make arrays with the names of the cities to put the locations in.

Does someone have a clue how i could best handle this?

what I actually want to do is making a form where people can select a city,(then a dropbox is filled with only the location of that city) and select a location.

Flientje

thorpe

ok... im only new to this stuff too, so this probably aint quite going to work. and im at work.... so i cant test it.

but here is my attempt. hope it gives you some ideas atleast.

<?php

  $cities = array(

$sydney = array('nth sydney','sth sydney','west sydney','east sydney'),
$melbourne = array('nth melbourne','sth melbourne','west melbourne','east melbourne')

  );

  foreach ($cities as $city) {

echo $city;

foreach ($city as $location) {

  echo $location;

}

  }

?>

flientje

yes this is basically what i want.. but.. I don't know how I should do this..

I guess I have to run through my result of my select. By doing this I can make a array(1) with the cities..

But then I want to make arrays that have the names of the values in the array(1) array.
so I guess I need to run through my array(1), and... ?
then I don't have a clue how I should make this new array.. 🙁

Like you I new at PHP.. so this should probably be a really stupid thought I'm not getting..

Flientje

laserlight

Suppose you have a table named tablename with a column named colname.
To select the colname field from all rows in tablename table and print them:

$query = "SELECT colname FROM tablename";
$result = db_query($query);
while ($row = db_fetch_array($result)) {
	echo $row['colname'];
}

You can easily adapt this for a drop down menu by printing the <select> tag before the loop, then setting the value attribute (and possibly the content) of the option element to $row['colname'], and finally printing </select> after the loop.

flientje

THANKS!! 😃

I can't try it yet.. but I think this is what I need..

grz Flientje

flientje

🙁 it's almost what I wanted..

I just would like to get " $row['colname'] " in an array that is named after the cities..

How can I name an array after a city without knowing what the name of the city?

Flientje