foreach() SQL query get just unique results

Question

I have a row performanta_cpu in my table modele and that row contain diferent numeric cpu's frecv. ex: 800, 1200, 1500, etc and i want to foreach all frecv. but if 4 devices have same cpu speed, shows me 4th times same frecv.

Is there posible to get just once a frecv in html <select> ex: 800, 1000, 1200, 1400, etc ?

Here is my code:

$sql = "SELECT * FROM $tbl_name ORDER BY performanta_cpu DESC";
    foreach ($dbh->query($sql) as $linie)
        {

    print '<option value="'.$linie["performanta_cpu"].'">'.$linie["performanta_cpu"].'</option>'; }?>

and this is what i get:

           <option value="800">800</option>
           <option value="800">800</option>
           <option value="2000">2000</option>
           <option value="2000">2000</option>
           <option value="1600">1600</option>
           <option value="1500">1500</option>
           <option value="1500">1500</option>
           <option value="1500">1500</option>
           <option value="1400">1400</option>
           <option value="1000">1000</option>
           <option value="1000">1000</option>
           <option value="1000">1000</option>
           <option value=""></option>

The correct will be like this:

           <option value="1600">1600</option>
           <option value="1500">1500</option>
           <option value="1400">1400</option>
           <option value="1300">1300</option>
           <option value="1200">1200</option>
           <option value="1100">1100</option>
           and so...

Gerardo Gómez · Accepted Answer · 2013-02-22 22:30:03Z

4

Change the query to

SELECT DISTINCT(performanta_cpu) FROM $tbl_name ORDER BY performanta_cpu DESC

answered Feb 22, 2013 at 22:30

Gerardo Gómez

1271 silver badge8 bronze badges

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

3 Comments

dev-null-dweller Over a year ago

DISTINCT is a keyword, not a function

Domuta Marcel Over a year ago

gerardo, is working but not as well, first is 800, 2000, 1600, 1500, 1400, etc. Why is there 800?

Domuta Marcel Over a year ago

800 is only one device in database with him, is unique, but in future it will be populated...

Rob · Accepted Answer · 2013-02-22 23:02:01Z

3

You could SELECT DISTINCT(performanta_cpu) FROM $tbl_name ORDER BY CAST(performanta_cpu AS UNSIGNED) DESC

edited Feb 22, 2013 at 23:02

answered Feb 22, 2013 at 22:30

Rob

12.9k4 gold badges44 silver badges57 bronze badges

3 Comments

Domuta Marcel Over a year ago

I get wrong first result like: 800, 1600, 1500, 1400, etc. First must be 1600 because is te biggest. Any Ideeas?

Rob Over a year ago

Sounds like you aren't using an integer field. Answer updated.

Lighthart Over a year ago

@Domuta Marcel 800, 1600, 1500 is sorted as string data, not integer, so 8 is a larger characeter than 1 and hence is first in the list.

serhat · Accepted Answer · 2013-02-22 22:34:03Z

1

If you will add DISTINCT, its must work.

SELECT DISTINCT(performanta_cpu) FROM $tbl_name ORDER BY performanta_cpu

answered Feb 22, 2013 at 22:34

serhat

53 bronze badges

4 Comments

Domuta Marcel Over a year ago

I get wrong first result like: 800, 1600, 1500, 1400, etc. First must be 1600 because is te biggest. Ideeas?

asclepix Over a year ago

Please, explain the meaning of DISTINCT option.

Lighthart Over a year ago

@Domuta Marcel 800, 1600, 1500 is sorted as string data, not integer, so 8 is a larger characeter than 1 and hence is first in the list. See Rob's answer.

Lighthart Over a year ago

@asclepix In context: If the query fetches '800' multiple times, DISTINCT only gives 1 instance of '800' back.

Winston · Accepted Answer · 2013-02-22 22:31:34Z

0

Try this

$sql = "SELECT * FROM $tbl_name ORDER BY performanta_cpu DESC";
$cpu = array();
foreach ($dbh->query($sql) as $linie)
    $cpu[] = $linie["performanta_cpu"];

$cpu = array_unique($cpu);

foreach($cpu as $val)
    print '<option value="'.$val.'">'.$val.'</option>'; }?>

answered Feb 22, 2013 at 22:31

Winston

1,8152 gold badges18 silver badges29 bronze badges

Collectives™ on Stack Overflow

foreach() SQL query get just unique results

4 Answers 4

3 Comments

3 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

3 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related