On 20-Sep-2001 Felix wrote:
> Hello all
>
> Can anyone suggest their best idea for a way to store IP addresses in a
> MySQL Database?
>
INT UNSIGNED
and use the MySQL functions INET_ATON() & INET_NTOA() for converting.
If you're on a pre-3.23 MySQL server then:
// Convert IP string (XXX.YY
Thank you very much.
Felix
- Original Message -
From: "Jason Bell" <[EMAIL PROTECTED]>
To: "PHP list" <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 12:49 PM
Subject: Re: [PHP] MySQl IP Address Storage
> Felix,
>
> Just to save you the
x27;));
SELECT INET_NTOA(ipaddress) FROM mytable;
Make sense?
- Original Message -
From: "Felix" <[EMAIL PROTECTED]>
To: "Robert Covell" <[EMAIL PROTECTED]>; "PHP list"
<[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 11:29 AM
Thank you Robert.
Felix
- Original Message -
From: "Robert Covell" <[EMAIL PROTECTED]>
To: "Felix" <[EMAIL PROTECTED]>; "PHP list" <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 10:55 AM
Subject: RE: [PHP] MySQl IP Addre
INET_ATON
and
INET_NTOA
-Original Message-
From: Felix [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 11:49 AM
To: PHP list
Subject: [PHP] MySQl IP Address Storage
Hello all
Can anyone suggest their best idea for a way to store IP addresses in a
MySQL Database?
Felix
Hello all
Can anyone suggest their best idea for a way to store IP addresses in a
MySQL Database?
Felix
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [E
6 matches
Mail list logo