inet_aton() and inet_ntoa() functions in php....
| From: | Kieu D. Trang | Date: | Mon, 19 May 2003 14:04:31 +0000 |
| Subject: | inet_aton() and inet_ntoa() functions in php.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27889@lists.php.net to get a copy of this message | ||
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