[RESOLVED] drop down menue

[rbblue8]

Hey guys,

I'm looking to have a drop down menue sort items in order and also have a current value selected based upon a value stored in mysql.

here is what i have so far.

  echo '<label>';
	   echo '<select name="rank">';
	   while ($rank = mysql_fetch_assoc($rank_result))
           echo '<span style="color:FFFFFF"><option>'.$rank['rank'].'</option>';
           echo '</select>';
           echo '</label>';
           echo '</div>';

Now the $rank = mysql_fetch_assoc($rank_result)) has two options to it. they are
$rank['rank'] and $rank['number'].

I wish to sort by $rank['number'] and have the menue select the current value stored in the mysql database which i will call $rank_current (script not included). Of course $rank_current will be one the options that's available in $rank['rank'].

Can ya help??

[devinemke]

the sorting you should do right from the query. you didn't say where $rank_current is coming from but i will assume that is from a separate query.

$result = mysql_query('SELECT * FROM ranks ORDER BY number') or exit(mysql_error());
echo '<select name="rank">';
while ($row = mysql_fetch_assoc($result))
{
	echo '<option';
	if ($row['rank'] == $rank_current) {echo ' selected';}
	echo '>' . $row['rank'] . '</option>';
}
echo '</select>';

[rbblue8]

sweet.

that works for me. The only thing that remains is to have the value selected based on the current $rank value. In this case the current $rank value is passed to this page by $row[6].

Can you help with that?

[devinemke]

rbblue8 wrote:

The only thing that remains is to have the value selected based on the current $rank value. In this case the current $rank value is passed to this page by $row[6]

...then use $row[6] instead of $rank_current

[rbblue8]

Hey,

The though process behind this is to allow admins to change the rank very easly. I want to have a drop down of all ranks but have the users current rank selected in the drop down menue.

THat's why I can not use $row[6].

[rbblue8]

 $result = mysql_query('SELECT * FROM ranks ORDER BY number') or exit(mysql_error());
echo '<select name="rank">';
while ($row = mysql_fetch_assoc($result))
{
    echo '<option';
    if ($row['rank'] == $rank_current) {echo ' selected';}
    echo '>' . $row['rank'] . '</option>';
}
echo '</select>'; 

that option does select the current rank value, however it delets all the other options that you could select from.

If i remove the

 if ($row['rank'] == $rank_current) {echo ' selected';}

all the options show back up.

what i want is for the current rank to be selected but still have the option to change to it the other options.

[crazychris]

note in the script chunk above, the <option> does not have a value='' assigned to it...

[rbblue8]

Yeah,

that's cuz I did not post the whole script. here ya go 🙂)

	  <?php

echo '<label>';
echo '<select name="rank">';
while ($rank = mysql_fetch_assoc($rank_result))
	{
	echo'<span style="color:FFFFFF"><option>'.$rank['rank'].'</option>';
	}
   	echo '</select>';
	echo '</label>';
	echo '</div>';
	?>

that gives me all the options.

  [code=php] <?php

echo '<label>';
echo '<select name="rank">';
while ($rank = mysql_fetch_assoc($rank_result))
	{
	if($rank['rank']==$rank_current)echo'<option>'.$rank['rank'].'</option>';
	}
   	echo '</select>';
	echo '</label>';
	echo '</div>';
	?>[/code]

only gives me the current selected value.

there has to be a way to get the best of both worlds

[rbblue8]

any thoughts on this?

[crazychris]

<?php 
print  "<select name=\"rank\">"; 
while ($rank = mysql_fetch_assoc($rank_result)) {	
	if ($rank['rank']==$rank_current) {
		$sel=" selected=\"true\"";
	} else {
		$sel="";
	}
	print "<option value=\"".$rank['rank']."\"".$sel.">".$rank['rank']."</option>";
}
print "</select>"; 
?>

[rbblue8]

Thanks,

That worked! 🙂