Populate drop down list from mysql in in php html

Question

I am using the below code to populate drop down list in php html,

<?php                       
$mid="mario";
$sql = "SELECT * FROM tbl_prdy WHERE col_master_id = '$mid'";

$result = mysqli_query($conn,$sql);
echo "<select name='list'>";
while ($row = mysql_fetch_array($result)) {
    echo "<option value='" . $row['col_of_fa'] . "'>" . $row['col_of_fa'] . "
    </option>";
}
echo "</select>";
?>

But, I am getting internal server error. I have debugged the code and found that the issue is with the following 2 lines in the above code. There is not much information in server logs. Can you tell me what might be the issue with the following 2 lines of code?

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

The beauty of this API is that it affords the use of parametrised queries — Strawberry
– Strawberry, Commented Jul 21, 2017 at 6:19

Arun Kumaresh · Accepted Answer · 2017-07-21 05:43:16Z

2

mixing mysqli with mysql

change

$row = mysql_fetch_array($result)

to

$row = mysqli_fetch_array($result)

answered Jul 21, 2017 at 5:43

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A.A Noman · Accepted Answer · 2017-07-21 05:47:16Z

0

You would use this

while($row=mysqli_fetch_assoc($result )){
}

or

while($row=mysqli_fetch_array($result )){
}

answered Jul 21, 2017 at 5:47

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

Comments

Pawan Thakur · Accepted Answer · 2017-07-21 05:52:30Z

0

//Try this :

while ($row = mysqli_fetch_array($result)) { ?>
    <option value="<?php echo $row['col_of_fa'] ?>" ><?php echo $row['col_of_fa'] ?>
    </option>
<?php }

answered Jul 21, 2017 at 5:52

Pawan Thakur

5918 silver badges19 bronze badges

Collectives™ on Stack Overflow

Populate drop down list from mysql in in php html

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related