Hi guys, need a little help with some modifications im trying to do.
I want to show in the guestbook, in the same line that the host and time of post, the username of the user that is posting that message. When i mean the username i mean the apache htaccess user not guestbook user.
I dont know php, but as i know quite a few other languages i can try to understand your suggestions.
First thing i did was modding add.class.php:
i added the var,
var $login;
then this in function addentry:
$this->login = $_SERVER['REMOTE_USER'];
and moddified this line to add my new var:
$this->db->query("INSERT INTO $sql_usertable (name,gender,email,url,date,location,host,login,browser,comment,icq,aim) VALUES ('$this->name','$this->gender','$this->email','$this->url','$the_time','$this->location','$host','$login','$agent','$this->comment','$this->icq','$this->aim')");
I tried to make it work with that and i get:
MySQL Error : Query Error
Error Number: 1054 Unknown column 'login' in 'field list'
Any suggestion?
Thanks!
|