avoid fetching Duplicate column

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    avoid fetching Duplicate column

    I have following data
    uk - 10
    in 9
    pk 9
    gb 4
    in 7
    pk 7
    I want to avoid Fetching Repeated column

    is it
    Code:
    while($fh = $db -> fetch("SELECT country,request FROM table_n GROUP BY id HAVING count(country) <= 1")){
    echo '".$fh[0]." ".$fh[1]."<br />';
    }
    output
    uk - 10
    in 9
    pk 9
    gb 4
    right way to fetch only one Entry
    Last edited by shushant; 05.05.12, 13:51.

    #2
    yeah cant see why not

    test it?:D

    Comment


      #3
      Originally posted by Matt_dowd91 View Post
      yeah cant see why not

      test it?:D
      Hey I m Using cellphone dats make too hard to Import query so I can't So I Want suggestion

      Comment


        #4
        PHP Code:
        while($fh $db -> fetch("SELECT country,request FROM table_n GROUP BY country")){ 

        Comment

        Working...
        X