Forum Moderators: coopster
echo '<select name="username">';while ($row=mysql_fetch_array($result) )
{
$username=$row['username'];$username=$username{0};
$username=explode(' ',$username);
$username=array_values(array_unique($username));
$username=implode(' ',$username);
echo '<option>';
echo"$username";
echo"</options>";
}
echo"</select>";
echo '<select name="username">';
$firstletters = array();
while ($row=mysql_fetch_array($result) )
{
$username=$row['username'];
$firstletters[]=$username{0};
$firstletters = array_unique($firstletters);
}
foreach ($firstletters as $value){
echo '<option>';
echo $value;
echo "</options>";
}
echo"</select>";