Re: client ip address

2004-09-30 Thread Laszlo Thoth
Quoting [EMAIL PROTECTED]: > You might look at the USER() and CURRENT_USER() functions. > > http://dev.mysql.com/doc/mysql/en/Information_functions.html Aha! I think this is what I was looking for: "the client host from which [I] connected". I'll have to do some in-query string processing to ex

Re: client ip address

2004-09-30 Thread SGreen
You might look at the USER() and CURRENT_USER() functions. http://dev.mysql.com/doc/mysql/en/Information_functions.html However, I think those will end up showing you the NAT server's address and not the user's un-NATed address. If it were simple to de-NAT an address, most firewalls would bec

Re: client ip address

2004-09-30 Thread Laszlo Thoth
Quoting Mazhar Bilen <[EMAIL PROTECTED]>: > Use this variable: > > $REMOTE_ADDR. > > Such that: > > $client_IP = $REMOTE_ADDR; > UPDATE clients SET ipaddr= $client_IP WHERE [EMAIL PROTECTED]; This doesn't appear to work: I don't think the MySQL server recognizes $REMOTE_ADDR as anything meaningfu

Re: client ip address

2004-09-30 Thread Mazhar Bilen
Use this variable: $REMOTE_ADDR. Such that: $client_IP = $REMOTE_ADDR; UPDATE clients SET ipaddr= $client_IP WHERE [EMAIL PROTECTED]; I hope this is useful for your code. Mazhar Bilen - Original Message - From: "Laszlo Thoth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, Sept