Repeating dropdown list

[mwenyenia07]

consider the following code:

$result=mysql_query($sql);
$datas=mysql_fetch_array($result);
$row=mysql_fetch_row($datas);
$num_rows=mysql_num_rows($result);
 for ($counter=0;$counter<$num_rows;$counter++) {

            echo("<option value={$datas[$counter]['name']}>{$datas['name']}</option>");
}

the problem is that it only picks the first record in the mysql database and duplicates it. can somebody help me solve this error

[cereal]

You have to use mysql_data_seek($result, $counter); inside the loop, so you can move the internal result pointer: http://www.php.net/manual/en/function.mysql-data-seek.php

here it is an example: http://www.daniweb.com/web-development/php/threads/396784/php-mysql-while-loop#post1702034

Bye!

[junior_rosul]

you can do it in while loop

while ($row = mysql_fetch_array($result)){
    echo "<option value = '".$row['name']."'>".$row['name']."</option>";
}