Query for distinct values in postgres and php

Question

I have the following code:

$sql_sd = select sd_code from stamp_den;
$rest2   = odbc_exec($conn,$sql_sd);
while(odbc_fetch_into($rest2,$row_s))
 {             
   $row_sd=$row_s[0];
 }
  //here i get sd_code as follows: 45, 46, 47, 48 etc
for ($i=0; $i<$td_date ;$i++)
 {
   $qu=select stamp_type from stamp_type where sd_code=$row_sd; 
 }

This whole code is inside another while loop.

Now in the for loop while executing the '$qu' query it takes values of sd_code as 45,45,45,45,46,46,46,46 etc depending upon the number of iterations.

How can I modify the code to take distinct values of sd_code while executing the $qu query. (45,46,47, etc)

If there is problem with the syntax please ignore, all variables and loops are declared. My code is executing properly, but not giving the desired o/p.

you can just you SQL like this => SELECT DISTINCT sd_code from stamp_den to receive distinct values from database — nanobash
– nanobash, Commented Jan 8, 2013 at 7:07
Possible duplicate of : stackoverflow.com/questions/6032796/… — sandip
– sandip, Commented Jan 8, 2013 at 7:09
@DaHaKa what you suggested is the real solution, why not post it as an answer and get some credit for your suggestion — Hanky Panky
– Hanky Panky, Commented Jan 8, 2013 at 7:09
Why aren't you just running SELECT sd_code, stamp_type FROM stamp_den JOIN stamp_code USING (sd_code) ORDER BY sd_code, stamp_type and then building a map of sd_codes to lists of stamp_types and work with that? They way you appear to be doing things now will probably generate in an order of magnitude or more of network traffic via database trips. — Matthew Wood
– Matthew Wood, Commented Jan 8, 2013 at 17:56

Hanky Panky · Accepted Answer · 2013-01-08 07:15:00Z

2

Try:

SELECT DISTINCT sd_code from stamp_den

DISTINCT is used to receive unique data from database.

edited Jan 8, 2013 at 7:15

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

answered Jan 8, 2013 at 7:10

nanobash

5,4967 gold badges41 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Query for distinct values in postgres and php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related