[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:

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

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 Address Storage INET_ATON and INET_NTOA -Original Message

Re: [PHP] MySQl IP Address Storage

2001-09-20 Thread Jason Bell
(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 Subject: Re: [PHP] MySQl IP Address Storage Thank you Robert. Felix - Original Message

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 headache that I encountered, the column that you

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