Ip select

[Ponick]

I know how to select user ip in their private profile . But my question is that how to select ip or show it in bihind of user nick in chat r00m ?
Please can any0ne help me ?

[Anshul]

Select userip from usertable where userid=chat_msg_poster_id;

[Ponick]

I tryed it . . .But n0t working . .

[Ponick]

I tryed it . . .But n0t working . .

im tryin this to chatroom

 echo "$ds $optlink";
                  
  
$avlink = getavatar($chat[0]);
if ($avlink!=""){

echo "<img src=\"$avlink\" alt=\"\"/>:";

}else{

$uipadd = mysql_fetch_array(mysql_query("SELECT ipadd FROM ibwf_users WHERE id='".$who."'"));
$IPaddress=$uipadd[0];






echo"<img src=\"flags/$two_letter_country_code.gif\" alt=\"$two_letter_country_code\" />:";
}
                  

                  echo" <b>$tosay</b><br/>";
                  }
                }
                              
                  $counter++;
                }

                }
            }
           
            echo "</p>"; 

but it show same flag in averywhere!

i think mysql is the main problem mysql_fetch_array(mysql_query("SELECT ipadd FROM ibwf_users WHERE id='".$who."'"));


can any one help?

[CreativityKills]

I dnt knw wats d issue bt this is gud coding practice: "".$two_letter_country_code."gif"; NOT $two_letter_country_code.gif

[Ponick]

kewmew get a look in my site. Then you will know the issu

its succesfully work in profile but in chat room its show your flag in avery where. Please get a l0ok.

[something else]

$uipadd = mysql_fetch_array(mysql_query("SELECT ipadd FROM ibwf_users WHERE id='".$chat[0]"'"));

[arg0s12]

Sir what's the table row for ibwf_user ipadd? Will you pls. Post?

[Mysterio]

say "thanks" to something else. That code should work.

[Ponick]

Thanx not working from m0bile .I must give thanx letter from pc

// i will post it (copy-past) 4m my pc letter argos