[RESOLVED] Problems populating data for array

schwim

Hi there everyone,

I don't understand arrays that well and am trying to modify one that someone else helped me with here previously.

I've created a table called classifieds_currencies which has four rows, id(incremental), symbol, abbreviation, description.

I'm trying to create a selection box dropdown for a form that will allow the user to choose their currency. I would like the option string to get populated like this:

<option value='1'>$ USD (United States Dollar)</option>

Which would be in the format of:

<option value='$id'>$symbol $abbreviation ($description)</option>

This is what I ended up with when modifying the array someone else had helped me with previously:

/*Generating currency dropdown.*/
				$query = "SELECT * FROM `classifieds_currencies` ORDER BY `id` ASC;";
				$result = mysql_query($query);
				$currencies = array();
				while ($row = mysql_fetch_assoc($result)) {
				  $currencies[$row['id']] = $row['symbol']." ".$row['abbreviation']." (".$row['description'].")";
				}


<--------------------cut--------------------------->

<select name='adcreate_currency' id='adcreate_currency'>");
								foreach ($currencies as $id => $abbreviation) {
									echo("<option value='".$id."'");

								/*Select the proper option if it's retrieved from the db.*/
								if($id == $adcreate_currency){
									echo(" selected");
								}

								echo(">".$title."</option>"."\n" );
							}
							echo("</select><br />

My array is populating only the id, so my option string looks like this:

<option value='1'></option>

Could anyone help me figure out where I went wrong so I have a working selection box?

thanks,
json

jgetner

you don't have the right formatting for your array i gather as you attempt to call all the id's from the array witch is just numbers as they are coming from the database id row. i dont think an array is your solution i think you should just populate variables preferably static so they will retain there values to save the data then call the var as needed.

schwim

Thanks very much for your reply. Static is not a preferable option as the entries will change over time and I'd rather not have to edit the code when one is added, but instead simply use the admin panel solution that I wrote to enter new currencies. As I understand it, an array would work fantastically for pulling a dynamic number of rows from the database and populating the options... especially since the person that helped me last time on this forum wrote such a fantastic solution with the exact same needs and outcome.

thanks,
json

cretaceous

your foreach is:

foreach ($currencies as $id=> $abbreviation){        

  ..cut...
echo(">".$title."</option>"."\n" );

but you are echoing $title
echo $abbreviation and you should be ok

...or change your foreach to : foreach ($currencies as $id=> $title){

schwim

Thank you so much for that. Making the change left me with a perfect solution to my problem.

Thanks again for taking the time to help!
json

cretaceous

your welcome.. !