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

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

Table sorting
Hi,

I'm trying to modify the following in order to make the output table sorted alphabeticall

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :

session checking in page load
hai all I have a web site is www.Mryas.com in this my login page is Page1.aspx its co

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I