I was wondering if someone can help me out with the problem that I am facing.
I am wanting to display user properties on link.html & detailed.html page along with the link proprties.
I have tried below sub but was not successful. (big thanks to Andy, who tried to help me out) :
sub {
my $user = $_[0];
$DB2 = new GT::SQL '/path/to/community/defs/';
$DB2->set_connect ({
driver => "mysql",
host => "localhost",
database => $dbname,
login => $user,
password => $pass
}) || die $GT::SQL::error;
$DB2->prefix("comm_");
my $get_hash = $DB2->table('Users')->select( { Username => $user } )->fetchrow_hashref || return $GT::SQL::error;
return { username => $get_hash->{comm_Username} };
}
What I am trying to do is, many users have more than one link, so even though the link information is different for every listing, company/link owner information like company name, address, email.. etc remains the same and it would be wonderful to have the ability to display all the user fields on the link.html and detailed page.
Thanks for the help.
Vishal
Vishal
-------------------------------------------------------