Hi,
If you are using GT::SQL, its pretty simple:
Code:
my $tbl = $DB->table('Links');
my $so = $IN->param('so') || "ASC"; # "sort order" ... i.e ASC or DESC
my $sb = $IN->param('sb') || "Title"; # "sort by" - i.e the field to search by...
$tbl->select_options("ORDER BY $sb $so LIMIT 100");
my $sth = $tbl->select( { isValidated => "Yes" } ) || die $GT::SQL::error;
my $count = $sth->rows;
while (my $hit = $sth->fetchrow_hashref) {
... now you have access to the $hit, which is the value from glinks_Links
}
Hard to really give a better explination, as I'm not really sure what you're trying to do =)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my
Amazon Wish List GLinks ULTRA Package | GLinks ULTRA Package PRO Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin |
Pre-Made Template Sets |
FREE GLinks Plugins!