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
plan
> to store your IP address in needs to be an unsigned integer when using
> INET_ATON and INET_NTOA
>
> If it's not, all addresses stored will come out as 127.0.0.0 (I think that
> was what it was...).
>
> Also, these are MySQL functions, not PHP functions. Not sure if you knew
> that already, but it wasn't specified on the list...
>
>
> INET_ATON converts from Decimal IP and INET_NTOA converts back to Decimal
> IP, so you'd use it like this:
>
> INSERT INTO mytable (ipaddress) VALUES (INET_ATON('192.168.1.1'));
>
> 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
> Subject: Re: [PHP] MySQl IP Address Storage
>
>
> > 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-----
> > > 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 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:
[EMAIL PROTECTED]
> > >
> > >
> > >
> > > --
> > > 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:
[EMAIL PROTECTED]
> >
> >
> > --
> > 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: [EMAIL PROTECTED]
> >
> >
>
>
> --
> 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: [EMAIL PROTECTED]
--
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: [EMAIL PROTECTED]
