[SOLVED] Drop down box with info from Mysql

[$username]

Hello all,

    I am looking to have a drop down box populated from data from MySQL.

I would like to have first name and last name in the value.

Is there something I am doing wrong?

 

echo "<option value=\"{.$row150['UserFirstName']..$row150['UserLastName'].}\"{$selected}>{$row150['UserFirstName']}</option>";

 

$sql150 = "SELECT UserFirstName, UserLastName FROM users";
//$sql150 = "SELECT CompState FROM standardvalues";
if ($result150 = mysql_query($sql150)) {
  while ($row150 = mysql_fetch_assoc($result150)) {
    $selected = ($row150['UserFirstName']==$ContactState)?" selected=\"selected\"":"";
   echo "<option value=\"{.$row150['UserFirstName']..$row150['UserLastName'].}\"{$selected}>{$row150['UserFirstName']}</option>";
  }
}

echo      " </select>
      </div></td>

 

Thanks

Brett

[revraz]

When you View Source, how does it display?

[$username]

Right now it does not display just shows blank

if I do this it works

 

echo "<option value=\"{$row150['UserFirstName']}\"{$selected}>{$row150['UserFirstName']}</option>";

 

thanks,

Brett

[revraz]

Now add your second variable right after it the exact same way.

[$username]

Thanks that did the trick

 

Brett