help gethostbyaddr($_SERVER['REMOTE_ADDR'])

[koolgirl]

Hi

got tired trying to solve this problem. I have been using the following script to store visitor's data. It is working fine:

<?php

$dbcnx = @mysql_connect(

'mysql','username','mypass');

mysql_select_db("Main");

$sql = "INSERT INTO Records SET " .

"IP='$REMOTE_ADDR', " .

"BrowserName='$HTTP_USER_AGENT', " .

"Language='$HTTP_ACCEPT_LANGUAGE', " .

"Referer='$HTTP_REFERER', " .

"Date=NOW()";

***********************************************

I want to store the user's host name also. I know this will display the host name on screen:

<?
echo "Your Host Name: " . gethostbyaddr($_SERVER['REMOTE_ADDR'])";

?>

************************************************

but the problem is how to store it in database? it returns error if I write it this way:

<?php

$dbcnx = @mysql_connect(

'mysql','username','mypass');

mysql_select_db("Main");

$sql = "INSERT INTO Records SET " .

"IP=gethostbyaddr($_SERVER['REMOTE_ADDR'])";

******************************************


All help would be very much appriciated. Many Thanks

[kenrbnsn]

Try this:
[code]<?php
$sql = "INSERT INTO Records SET IP='" . gethostbyaddr($_SERVER['REMOTE_ADDR']) . "'";
?>[/code]

Ken

[poirot]

-Alternative Syntax-

[code]<?php
$sql = "INSERT INTO `records` (IP) VALUES ('" . gethostbyaddr($_SERVER['REMOTE_ADDR']) . "')";
?>[/code]

[kenrbnsn]

No, using the "Set" is an alternative syntax for INSERT. It works fine. I use it all the time.

Ken

[poirot]

Heh, my bad. I like this forum because you always learn something :)