Problem submitting data to a database.

[huck]

Ok. I'm sure this is a super simple fix, but for some reason I'm not seeing it. Any help would be good.

The PHP is designed to capture certain information about the site visitor, and then store them in a database. Simple, really. The information is being captured, but for some reason, it's inputting the variable names into the database, instead of the values.

I'm assuming it's something to do with the variable names being in brackets?

Code below. (The relevant section)

$date = date("D dS F, Y");
$time = date("g:i:sa"); //find out how to get this back into GMT
$ip = $_SERVER['REMOTE_ADDR'];
$referer = $_SERVER['HTTP_REFERER'];
$useragent = $_SERVER['HTTP_USER_AGENT'];
/*Adds the data to the database*/

$db = "databasename";
$result = mysql_select_db($db) or die("Unable to select the database, but could connect to server");

$adduserinfo = 'INSERT INTO `userlogging` (`ID`, `date`, `time`, `IP`, `browser`, `referer`) VALUES (\'\', \'$date\', \'$time\', \'$ip\', \'$useragent\', \'$referer\')';
$adduserinforesult = mysql_query($adduserinfo) or die ("Error in query $adduserinfo");

[etono]

Format your SQL statement like this:

$sql = "INSERT INTO userlogging
         ( ID, date, time, IP, browser, referer )
         VALUES ( '', '$date', '$time', '$ip', '$useragent', '$referer' )";

You mentioned about variable names being in brackets. In this case I will assume that your variables are coming from an array called "clean":

$sql = "INSERT INTO userlogging
         ( ID, date, time, IP, browser, referer )
         VALUES ( '', '{$clean['date']}', '{$clean['time']}', '{$clean['ip']}', '{$clean['useragent']}', '{$clean['referer']}' )";