Trouble with a select list

Posted on 16th Feb 2014 07:03 pm by admin

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

Your Answer:

Login to answer

Other forums

Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma

How to use php and sql to check if values match the ones in a table (for logins)
How would I code it that the script takes two variables that are passed to it (UserID and PIN), and

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is

php require help needed
Ok i tried to use the search funtion but the word require is everywhere.

i'm really new to cr

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way