[Resolved] Drop down boxes

[Calahan]

Well I thought I had it licked but it seems I was wrong.

This is what I have so far......

//Verify that the link to the database is alive//
$link_id = mysql_pconnect($Host, $User, $Pass) or die(mysql_error());

//Select the database defined as $DB in employee_common.php//
mysql_select_db($DB);

//Select all usernames held in the employee database and assign this query to the variable $username//
$username_query="SELECT username FROM employees";

//Submit the $username_query to the database and assign the results to the variable (array) called $usernames//
$usernames=mysql_query($username_query) OR die(mysql_error());

//Step through the array called $usernames and extract each entry. Print each entry on the screen one after the other//
while($row = mysql_fetch_array($usernames))
{
echo "$row[username]<br>";
}
?>

I can get the entries onto the screen but I can't seem to use them to populate a drop down box despite trying everything I could find on the boards.
I have searched the forum and the web for the last hour or so all to no avail so if someone wouldn't mind giving me a few pointers, I'd appreciate it.

[eternalprophet]

echo "<SELECT NAME=\"empname\">";

while($row = mysql_fetch_array($usernames)
{
echo "<OPTION VALUE=\".$row[usernames]."$row[usernames]";
}

echo "</SELECT>";

something like that?

It may be off a little, but thats the general idea I think. I did not see any code in your script to output any form of drop down box

You also have
white($row = mysql_fetch_array($usernames) but use usename in the code ----$row[username]

that might make a difference too.

I could be way off though :0 I am new to this as well.

[helz]

username in the $row['username'] is the field name in the db.

your sample code is good just a little off like you said:

echo "<SELECT NAME=\"empname\">"; 

while($row = mysql_fetch_array($usernames) 
{ 
echo "<OPTION VALUE='".$row[username]."'>".$row[username]."</option>"; 
} 

echo "</SELECT>"; 

[eternalprophet]

Not as far off as I thought 🙂

Thanks for fixing what I was trying to fix 🙂

Did this stuff help you helz?

[Calahan]

I've just looked over the suggestions and yes, the suggestions fixed my problem.

Thanks for everyone's help!