On Monday 19 May 2003 22:04, Kieu D. Trang wrote: > does anyone know how to use these 2 functions in mySQL? > inet_aton() and inet_ntoa()? I'm sure someone on the mysql list will be able to tell you. > i have this select statement, and it gives me an error... And what is this error? You never know it may help in working out what the problem is. > SELECT COUNT(*) FROM ptr_table WHERE ip >=INET_ATON(123.0.0.0) AND ip > <=INET_ATON(123.255.255.255); Try INET_ATON('123.0.0.0') -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* Television is a medium because anything well done is rare. -- attributed to both Fred Allen and Ernie Kovacs */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php