Hi all,
im looking for a special query to get all new links for a special category.
Without having alternate cats, it seems no problem, but with it i dont get till now:
I think it must be something like:
get all the LinkdID from CategoryAlternates WHERE CategoryID = X
(SELECT * FROM CategoryAlternates WHERE CategoryID = x)
putting in an array:
while ($link = $sth->fetchrow_hashref) { ???? }
Then something like:
SELECT * FROM Links WHERE CategoryID = x AND all from array order by $LINKS{build_sort_order_home} LIMIT 5!
Hope someone knows more about that mine.
Robert
im looking for a special query to get all new links for a special category.
Without having alternate cats, it seems no problem, but with it i dont get till now:
I think it must be something like:
get all the LinkdID from CategoryAlternates WHERE CategoryID = X
(SELECT * FROM CategoryAlternates WHERE CategoryID = x)
putting in an array:
while ($link = $sth->fetchrow_hashref) { ???? }
Then something like:
SELECT * FROM Links WHERE CategoryID = x AND all from array order by $LINKS{build_sort_order_home} LIMIT 5!
Hope someone knows more about that mine.
Robert