Dropdown from database without duplicate data

Question

I'm trying to create a dropdown list of my product type from the database, I'm using this code from How to populate HTML dropdown list with values from database.

<select name="product_type">
<?php 
include('include/conn.php');
$sql = mysql_query("SELECT product_type FROM produk2");
while ($row = mysql_fetch_array($sql)){
echo "<option value=\"product_type1\">" . $row['product_type'] . "</option>";
}

?>
</select>

I'm going to add this in my search engine, but the dropdown from that code making it read all data from product_type. Is it possible to create the dropdown without the same product_type twice?

You are looking for distinct result. You could use DISTINCT or GROUP BY. By the way, you should at least use mysqli or even better, PDO. — Osh Mansor
– Osh Mansor, Commented Sep 9, 2015 at 3:08
Please, don't use mysql_* functions, They are no longer maintained and are officially deprecated. Learn about prepared statements instead, and use PDO or MySQLi. This article will help you decide. — Luke
– Luke, Commented Sep 9, 2015 at 4:43

Glenn Mcshane · Accepted Answer · 2015-09-09 04:41:53Z

1

You should at least connect using mysqli :

conn.php =

 $con=mysqli_connect("server","username","password","database");
            // Check connection
            if (mysqli_connect_errno())
            {
                echo "Failed to connect to MySQL: " . mysqli_connect_error();
            }

Then your query file :

   <select name="product_type">
<?php 
include('include/conn.php');
$sql = mysqli_query($con,"SELECT product_type FROM produk2 GROUP BY product_type")
while ($row = mysqli_fetch_array($sql)){
echo "<option value=\"product_type1\">" . $row['product_type'] . "</option>";
}

?>
</select>

answered Sep 9, 2015 at 4:41

Glenn Mcshane

559 bronze badges

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

1 Comment

Mohd Fadli Over a year ago

im just starting to understand mysql and now it is really hard for me to try and change to use mysqli,

Collectives™ on Stack Overflow

Dropdown from database without duplicate data

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related