RE: [PHP] MySQl IP Address Storage

2001-09-20 Thread Don Read
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

Re: [PHP] MySQl IP Address Storage

2001-09-20 Thread Felix
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

Re: [PHP] MySQl IP Address Storage

2001-09-20 Thread Jason Bell
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

Re: [PHP] MySQl IP Address Storage

2001-09-20 Thread Felix
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

RE: [PHP] MySQl IP Address Storage

2001-09-20 Thread Robert Covell
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

[PHP] MySQl IP Address Storage

2001-09-20 Thread 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