Populate drop-down list with MySQL query in PHP

Question

I want to use the following code to populate a drop-down list with all of the customer types:

<select name="type" id="type" class="neutral">
<?php   // SQL QUERY TO RETRIEVE EVERY TYPE OF CUSTOMER
$sql = "SELECT CUST_TYPE FROM `CUSTOMER` GROUP BY `CUST_TYPE`";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){echo '<option value="'.$row.'">'.$row.'</option>';}
                ?>

The query works in phpMyAdmin; it gives the correct output (corporate, other, school, sports) but in the webpage it displays a drop-down list with 4 options, all containing the word "array." Please help!

print_r($row) to see what is in there -- it is a 2D array, so you need $row['CUST_TYPE'] — Michael Berkowski
– Michael Berkowski, Commented Nov 30, 2012 at 14:59
A side note about your query - you are not using any aggregate functions and so although your GROUP BY probably gives you the result you expect, more appropriate would be to SELECT DISTINCT CUST_TYPE FROM CUSTOMER — Michael Berkowski
– Michael Berkowski, Commented Nov 30, 2012 at 15:06

Jarrod Sears · Accepted Answer · 2012-11-30 15:00:18Z

2

Try

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

answered Nov 30, 2012 at 15:00

Jarrod Sears

1,1303 gold badges17 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Populate drop-down list with MySQL query in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related