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, Dec 11 '16 at 10:56
http://stackoverflow.com/questions/854128/find-duplicate-records-in-mysql — , Dec 11 '16 at 10:57
you didn't put any effort to write a clear question, I don't know why we should provide you a clear answer. We don't know what you want to do. — Federkun, Dec 11 '16 at 11:14
your answer is right bro! SELECT DISTINCT is clearly working in mysql but when i'm putting it in PHP it's giving and error of offset — Jawad Ajaz, Dec 11 '16 at 11:21

score 1 · Answer 1 · answered Jan 28 '20 at 19:47

1

Your query should be

SELECT * FROM areas GROUP BY id

I have tested it.

answered Jan 28 '20 at 19:47

Rajesh

15
6

Iarwa1n · Answer 2 · 2016-12-11T11:47:55.553

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 '16 at 11:47

answered Dec 11 '16 at 11:02

Iarwa1n

438
2
11

I forgot a $. Please be more specific and try to debug yourself before asking for more help – Iarwa1n Dec 11 '16 at 11:48

Remove Duplicate Values From Select Option In PHP

2 Answers2