tommytoxen

Hi guys. I'm modifying my CometChat to display guest user IP addresses to moderators. I've successfully got ip addresses of guests to save in the database in ip2long format. Now I need to retrieve and print an IP address of a user to a moderator when they click the guest's username The code I need to print the IP address is here: if($owner == 1 || in_array($userid,$moderatorUserIDs)) { $options="<input type=button value='".$chatrooms_language[40]."' onclick=javascript:".$caller."kickUser($uid,0);$close class='invitebutton'> <input type=button value='".$chatrooms_language[41]."' onclick=javascript:".$caller."banUser($uid,0);$close class='invitebutton'>".$options; This shows a KICK & BAN button. Either above or below them I need it to say IP: - the guest's IP- The ip2long IP address is stored in cometchat_guests in the column 'ip' I need to put: SELECT INET_NTOA(ip) FROM 'cometchat_guests' WHERE 1 But I'm not sure what goes after WHERE... WHERE what? WHERE 1 = $uid Or WHERE $uid = 1 echo $ip Would be very grateful and appreciate any help here, thank you so much in advance I'm getting a migraine here