(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [mkoenig] DISTINCT in Globals: Edit Log

Here is the list of edits for this post
Jan 18, 2004, 2:26 AM
afinlr
Veteran (1921 posts)
Jan 18, 2004, 2:26 AM
Views: 2231
Re: [mkoenig] DISTINCT in Globals
I think you need to remove the curly brackets

select( 'DISTINCT(LinkOwner)' );

and also change fetchrow_hashref to fetchrow_array

and then $link will contain the value of the Username so you just need

output .= qq ~<tr><td width="10%" height="25">$link</td></tr>~;

Oh and you need a condition statement.

my $cond = GT::SQL::Condition->new( 'isValidated','=','Yes','CategoryID', 'IN', \@$all_ids);
my $sth = $link_db->select( ['DISTINCT(LinkOwner)'],$cond);

I think that's about it.

Last edited by:

afinlr: Jan 18, 2004, 2:34 AM

Edit Log: