If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
help with modification  XML
Forum Index » Advanced Guestbook Forum
Author Message
pinkster
Newbie

Joined: 04/12/2006 22:19:31
Messages: 4
Offline

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!
pinkster
Newbie

Joined: 04/12/2006 22:19:31
Messages: 4
Offline

anyone?? i have been hours trying to figure it out with no luck...
it shouldnt be hard, im just missing something...
i would really apreciate any kind of help.
pinkster
Newbie

Joined: 04/12/2006 22:19:31
Messages: 4
Offline

problem solved.
thx anyway
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum