echoing users data from mysql

[graham23s]

Hi Guys,

when users on my site look at they're profile details some of the data in like this:

<select name="somename">
<option value="Option 1">Option 1</option>
<option value="Option 2">Option 2</option>
</select> 

once a user has selected an option and it's stored in mysql, i was wanting the specific information to be displayed in the drop down box, if i selected option 2 next time i log in option 2 is displayed and so on.

what would be the best way to achieve this?

thanks guys

Graham

[byron3@earthlink]

Graham,

When you loop through the available values creating your selection list use an if clause to check the returned value against the users value, if they are the same then in the option tag echo selected option selected="selected">

[graham23s]

Hi Mate,

kinda like this:

<select name="somename">
<option value="Option 1">Option 1</option>
if(somename == $somename) {

echo "<option value="Option 1">$somename</option>";

}
<option value="Option 2">Option 2</option> 
</select> 

is that along the correct lines mate?

thanks

Graham

[byron3@earthlink]

?>
<select name="this_field">
<?php
while ( $row=mysql_fetch_assoc( $results ) {
    if ( $Users_Data_Value == $row['Field_to_Compare']) {
        echo "<option value=\"Option 1\" selected=\"selected\">Option 1</option>";
    } else {
        echo "<option value=\"Option 2\">$Option 2</option>"; 
    }
}
?>
</select>
<?php

More like this Graham.

[graham23s]

Thanks for the help mate

Graham

[byron3@earthlink]

My pleasure...

Byron