Help me, please!

[virva]

I have a code like this, and it's included at a html page. But this insert-clause doesn't work. I thought it would work as the page is loaded. Why doesn't it? What should I do?

<?php

include_once("functions.php");

//get visitor's ip address
if (getenv(HTTP_X_FORWARDED_FOR)){
$ip = getenv(HTTP_X_FORWARDED_FOR);
}
else {
$ip = getenv(REMOTE_ADDR);
}

//get date
$pvm = date("j.n.Y");

//get the page visitor comes from
$sivu = getenv("HTTP_REFERER");

$insert = "INSERT INTO kayttajainfo (ip, pvm, sivu) VALUES ('$ip', '$pvm', '$sivu')";

?>

Thank you so much!

[_SuperString]

You have only assigned the Insert value as a string to the variable $insert, you still need to call the database query function to have it executed. Try this:

$insert = "INSERT INTO kayttajainfo (ip, pvm, sivu) VALUES ('$ip', '$pvm', '$sivu')";

if(!mysql_query($insert)) { 
     echo "The insert failed with the error: ".mysql_error();
} else {
     echo "The insert worked !!";
}

Hope this has put some light on it. 🙂

[virva]

I knew I was missing something... 🙂 I just didn't know how to write it. Thanks a lot.