auto select dropdown from database?

as you all should know by now, im quite a n00b at PHP, im a beginner, and i barely know the basics as it is.. but im having this problem.. i have modified php fusion (even further than I have mentioned before) and now, you can have a special rank, well this is an ID# from the database for each user, say if they have user_clanrank = 3, their rank is leader or something.. well.. when i go to the admin panel to update their rank, that drop down menu from where you select their rank is always RESET so if you dont change it back each time, it will change it in the DB. any idea how to make it select your current rank automatically?

Code:

echo "
<tr>
<td class='tbl'>Clan Rank:</td>
<td class='tbl'>";
echo "
<select size='1' name='user_clanrank' class='textbox'>
<option selected>Choose One</option>
<option value='1'>Public User</option>
<option value='2'>Inactive Member</option>
<option value='3'>Trial Member</option>
<option value='4'>Clan Member</option>
<option value='5'>Event Coordinator</option>
<option value='6'>Elite</option>
<option value='7'>Emissary</option>
<option value='8'>Legendary Member</option>
<option value='9'>Board of Advisory</option>
<option value='10'>Overseer</option>
<option value='11'>Kingpins Aide</option>
<option value='12'>Kingpin</option>
<option value='13'>Clan Friend</option>
<option value='14'>Trusted Clan Friend</option>
<option value='15'>Allied Clan Member</option>
</select>";

check this function/snippet:

http://www.finalwebsites.com/snippets.php?id=21

[Join us @ facebook]

Or you can use an associative array, like this:

Code:

<?php
$values = array(
  1 => 'Public User',
  2 => 'Inactive Member',
  3 => 'Trial Member', 
);

This array should have all the possible values. Then if for example you have store the user's rank in a variable called $rank, you can do this :

Code:

<?php
foreach ( $values as $id => $r )
{
 echo '<option value="'.$id.'"'.($id==$rank?' selected':'').'>'.$r.'</option>';
}

Hope that helps

Hope that helps Wink

important is that the current value from the database is selected during form submission.

ok thx everyone for the responses, im gonna try your method first Nik, will post here if i have any more issues


god i love this forum..

here is my completed version of the snippet to do this, and it worked first try. thanks alot nik, tell me if this is right though:

Code:

<?php echo "
<tr>
<td class='tbl'>Clan Rank:</td>
<td class='tbl'>"; 
$values = array(
  1 => 'Public User',
  2 => 'Inactive Member',
  3 => 'Trial Member', 
  4 => 'Clan Member',
  5 => 'Event Coordinator',
  6 => 'Elite',
  7 => 'Emissary',
  8 => 'Legendary Member',
  9 => 'Board of Advisory',
  10 => 'Overseer',
  11 => 'Kingpins Aide',
  12 => 'Kingpin',
  13 => 'Clan Friend',
  14 => 'Trusted Clan Friend',
  15 => 'Allied Clan Member',
);
echo "
<select size='1' name='user_clanrank' class='textbox'>";
foreach ( $values as $id => $r )
{
 echo '<option value="'.$id.'"'.($id==$data['user_clanrank']?' selected':'').'>'.$r.'</option>';
}
echo "</select>"; ?>

[Join us @ facebook]

It seems that you have learned php in the months past meth0d

The code you posted needs a small correction, here is the right one:

Code:

<?php echo "
<tr>
<td class='tbl'>Clan Rank:</td>
<td class='tbl'>"; 
$values = array(
  1 => 'Public User',
  2 => 'Inactive Member',
  3 => 'Trial Member', 
  4 => 'Clan Member',
  5 => 'Event Coordinator',
  6 => 'Elite',
  7 => 'Emissary',
  8 => 'Legendary Member',
  9 => 'Board of Advisory',
  10 => 'Overseer',
  11 => 'Kingpins Aide',
  12 => 'Kingpin',
  13 => 'Clan Friend',
  14 => 'Trusted Clan Friend',
  15 => 'Allied Clan Member'
);
echo "
<select size='1' name='user_clanrank' class='textbox'>";
foreach ( $values as $id => $r )
{
 echo '<option value="'.$id.'"'.($id==$data['user_clanrank']?' selected':'').'>'.$r.'</option>';
}
echo "</select>"; ?>

ok if possible can you explain why you made that change and what difference it makes? curious this is how i learn

edit: looking at what you did i dont even see a change ;o

ok if possible can you explain why you made that change and what difference it makes? curious this is how i learn

edit: looking at what you did i dont even see a change ;o

me too

[Join us @ facebook]

In the end of the array statement you had an extra ,

In the end of the array statement you had an extra ,

yes all this small thinks more bad is a almost invisble "backtick"

[Join us @ facebook]

In the end of the array statement you had an extra ,

yes all this small thinks more bad is a almost invisble "backtick"

I remember countless times searching why the script is not working, and you finally find that , ........

yes me too, place for the backtick "`" in a php script there error is much more fun

ah ok, tyvm for the help on this one

[Guest]

[62.871]

Googlebot, Msnbot, hobbit, Yahoo crawler