[RESOLVED] Problems with a select list

[dariuc]

Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

I'm trying to add a select list to a form on my webpage.

The select list is generated from information stored in a database.

The table has 25 rows in it presently and what I'm trying to do is list only one column of the rows to create a select list.

An example of this:

Populating a select list with all of the names in a member database.

Here is the relevant code:

$ReqQry=" SELECT `traitname` FROM `traitslist` ";
$ReqResult= mysqli_query($cxn , $ReqQry)or die('Ya did it wrong');
$TraitInfo= mysqli_fetch_assoc($ReqResult);
$TraitCnt= mysqli_num_rows($ReqResult);



$list1=$TraitCnt;

echo "Required Skill 1-"."</br>";
echo "<select id='Req1'>";

foreach($TraitInfo as $v)
{
while($list1 > 0)
{
		echo "<option  value='$v'>$v</option>";
$list1--;
}


}
echo "</select>"."</br></br>";

The problem that I am having is that the select list generates the same entry 25 times.

Any help would be appreciated, as I have fiddled around with it for about two days in my off-time and no luck yet. Thanks
ps I'm still rather wet behind the ears with PhP so be gentle 😃

[rincewind456]

Like this:

$ReqQry=" SELECT `traitname` FROM `traitslist` ";
$ReqResult= mysqli_query($cxn , $ReqQry)or die('Ya did it wrong');
$TraitCnt= mysqli_num_rows($ReqResult);

$list1=$TraitCnt;

echo "Required Skill 1-</br>";
echo "<select id='Req1'>";

while($row=mysqli_fetch_assoc($ReqResult))
{
        echo "<option  value='".$row['traitname']."'>".$row['traitname']."</option>";

}

echo "</select></br></br>"; 

[dariuc]

Much appreciated.🆒