SG> Correction - this one is wrong, it will list each entry only once. confirmed :)
>> SELECT position1 as position,title WHERE position1 IN ($_) UNION >> SELECT position2 as position,title WHERE position2 IN ($_) ORDER BY position; SG> This one is ok. what about a way that would work with 3.23 ? :)) (ah, damn real-life admins, who don't want to upgrade before 6 months of proven reliability) PS: i add the following words to pass the spam filter :) database sql query table -- Boris Hajduk [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php