Remove Duplicate Values From Select Option In PHP

Question

here's the code and i want to echo only 1 city from mysql database!

<?php


include('db.php');

    $queryss = mysqli_query($conn, 'SELECT * FROM areas');

    while ($rowx = mysqli_fetch_array($queryss)) {


        echo "{pro:'$rowx[1]',city:'$rowx[2]', dist:'$rowx[3]', town:'$rowx[4]', area:'$rowx[5]',subarea:'$rowx[6]',ucname:'$rowx[7]'},";

    }

    ?>

and i'm, getting this input here! 3 time karachi in my html, but i want only 1 of this city. SELECT DISTINCT is working in mysql but how can i use it in PHP?

i've entered duplicate values in mysql, now i want that when i fetch them then i'll get only 1 value, rest of the duplicate values should be deleted — Jawad Ajaz
– Jawad Ajaz, Commented Dec 11, 2016 at 10:56

Rajesh · Accepted Answer · 2020-01-28 19:47:20Z

1

Your query should be

SELECT * FROM areas GROUP BY id

I have tested it.

answered Jan 28, 2020 at 19:47

Rajesh

307 bronze badges

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

Comments

Iarwa1n · Accepted Answer · 2016-12-11 11:47:55Z

0

Use

SELECT DISTINCT column_name1,column_name2 FRAM areas

in your SQL where column_nameN stands for the columns you need for your output.

OR use something like this (untested):

$results = [];
while ($rowx = mysqli_fetch_array($queryss)) {
    $results[] = $rowx;
}
$results= array_unique($results);
foreach($results as $rowx) {
    echo "{pro:'$rowx[1]',city:'$rowx[2]', dist:'$rowx[3]', town:'$rowx[4]', area:'$rowx[5]',subarea:'$rowx[6]',ucname:'$rowx[7]'},";
}

edited Dec 11, 2016 at 11:47

answered Dec 11, 2016 at 11:02

Iarwa1n

4603 silver badges12 bronze badges

1 Comment

Iarwa1n Over a year ago

I forgot a $. Please be more specific and try to debug yourself before asking for more help

Mahmoud Ramadan · Accepted Answer · 2022-09-11 13:23:35Z

0

First Solution

You can insert distinct keyword into your SQL to accomplish what you need, like so

SELECT DISTINCT your_column_name FROM table_name

Second Soltion

You can execute your SQL statement and then use array_unique, to be like so

$selectStatement = mysqli_query($con, 'SELECT * FROM areas');

$selectedArrayValues = mysqli_fetch_array($selectStatement);

$selectedUniqueArrayValues = array_unique(selectedArrayValues);

// Then return that array to your HTML code

I recommend the first solution because it's more optimized

answered Sep 11, 2022 at 13:23

Mahmoud Ramadan

6829 silver badges16 bronze badges

Collectives™ on Stack Overflow

Remove Duplicate Values From Select Option In PHP

3 Answers 3

Comments

1 Comment

First Solution

Second Soltion

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

First Solution

Second Soltion

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related