hi all.. does anyone know how to use these 2 functions in mySQL? inet_aton() and inet_ntoa()? i have this select statement, and it gives me an error... SELECT COUNT(*) FROM ptr_table WHERE ip >=INET_ATON(123.0.0.0) AND ip <=INET_ATON(123.255.255.255); these are not PHP built in function... I guess i can make them user defined functions... before i tried that SELECT statement.... I converted the ip using ip2long() function, but this sometimes gives me a negative number... so no luck in that... :( any help would be appreciated....... KD -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php