Clever Forms

[simon622]

hi guys,

I have a small quandry. I need to make a form clever, and set a form select element dynamically, eg depending on what is in the database, set the default form value to that. For example, country select, if the user is from US, automatically set all country selects to US.

I understand I have to move the <option selected> element however some of my lists are quite long, and I dont want to write incredibly long conditionals to insert it dynamically. Is there a quick greasy work around i dont know about?

Any help would be great.

Thanks,

[bastien]

just one

what you want to do is to take the list of countries from a DB table ( makes it real easy) and then get the data for the user

<?

$sql_country="select * from tbl_country";

$result=mysql_query($sql_country);

$sql_userdata ="select * from tbl_users where userid = $userid";

$result2=mysql_query($sql_userdata);

do while ($row=mysql_fetch_row($result2)){
//assign data to a var - assume store country ID code
$countryofresidence=$row['country'];

}
//lets create the box

echo "<select name=\'country\'>";

//loop through the data for select box

do while ($rows=mysql_etch_array($result)){
$countryid = $rows['country_id'];
$country=$rows['countryname'];

   if ($countryofresidence==$countryid){
      echo "<option value=\'$countryid\' SELECTED>$country</option>";
  }else{
     echo "<option value=\'$countryid\'>$country</option>";
  }

} // end do loop for select box

?>

hth

[simon622]

Cheers that was great,

Although i have opted rather than using a DB for the options, to just stick values in an array and then loop through the array performing the same check.

Thanks alot for the idea,

sometimes can't see for looking!!

Si