Hi Andy,
I use your Global like this :
my $field = $_[0];
my $table = $DB->table('Links');
my $cond = new GT::SQL::Condition('City','=','CityName');
$table->select_options('ORDER BY City ASC');
my $sth = $table->select($cond, ["DISTINCT($field)"] );
my $back = qq||;
while (my ($name) = $sth->fetchrow_array) {
$back .= qq|<a href="$name">$name</a> - |;
}
return $back;
}But, I would like to obtain 2 information to build my link like this :
<a href= "$name1">$name2</a>
You think that it is possible ?
Thank you for your assistance.
Mick
I use your Global like this :
Code:
sub { my $field = $_[0];
my $table = $DB->table('Links');
my $cond = new GT::SQL::Condition('City','=','CityName');
$table->select_options('ORDER BY City ASC');
my $sth = $table->select($cond, ["DISTINCT($field)"] );
my $back = qq||;
while (my ($name) = $sth->fetchrow_array) {
$back .= qq|<a href="$name">$name</a> - |;
}
return $back;
}
<a href= "$name1">$name2</a>
You think that it is possible ?
Thank you for your assistance.
Mick