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