I have a problem with this:
my $cat_db = $DB->table ('Links','CatLinks','Category');
$cat_db->select_options ("ORDER BY ID ", "LIMIT 8");
my $sth = $cat_db->select (['Links.ID','Contact_Name','Logo','Ort','Name2'],
GT::SQL::Condition->new ('Logo','!=','',
'isValidated','=','Yes',
'visible','=','Yes'
) );
Because most of the links are in more than one category, i got no unique links with the query above.
The query now is: SELECT * FROM Links, CatLinks, Category WHERE ... but i need something like:
SELECT DISTINCT FROM Links, CatLinks, Category WHERE ...
Shurely i can use a query without a LIMIT and compare the IDs stoppting with a while counter=8;
but it should be with one query, i hope. Some ideas?
Code:
my $cat_db = $DB->table ('Links','CatLinks','Category');
$cat_db->select_options ("ORDER BY ID ", "LIMIT 8");
my $sth = $cat_db->select (['Links.ID','Contact_Name','Logo','Ort','Name2'],
GT::SQL::Condition->new ('Logo','!=','',
'isValidated','=','Yes',
'visible','=','Yes'
) );
Because most of the links are in more than one category, i got no unique links with the query above.
The query now is: SELECT * FROM Links, CatLinks, Category WHERE ... but i need something like:
SELECT DISTINCT FROM Links, CatLinks, Category WHERE ...
Shurely i can use a query without a LIMIT and compare the IDs stoppting with a while counter=8;
but it should be with one query, i hope. Some ideas?
SELECT DISTINCT