SQL IF problem

[stew]

SELECT log.identity, list.listed_user
FROM biffy_lists AS list, online_log AS log
WHERE list.active_user =  '$user_login' AND list.name_list =  'buddy'
IF ( log.identity = list.listed_user )

hey there guys, im getting an error at the start of IF... i've checked the manual but it is quite hard to decipher!! anyway the IF is trying to select log.idenity if the same value is present in another table (list) and field (listed_user), then to output it into an array. if i can get the sql statement right im sure the rest will follow!

cheers for any help you can give!

stew

[tsinka]

Hi,

change the query to:

SELECT log.identity, list.listed_user 
FROM biffy_lists AS list, online_log AS log 
WHERE log.identity=list.listed_user AND list.active_user =  '$user_login' AND list.name_list =  'buddy'

Thomas