converting subquery to mysql 4.0 compliant.. need help

[APuppyDog]

I have a page that works fine in php5 but the same code does not work in php4. Due to the circumstances, i have to make it work in php4 for the time being... can you gurus suggest how I can resolve this to work with php4?

SELECT distinct car_auctions.leading_bidder 
FROM car_auctions 
WHERE car_auctions.auction_closed=1 
AND car_auctions.buyer_fees>0 
AND car_auctions.buyer_fees_charged_status<>1 
AND car_auctions.leading_bidder 
 in (SELECT user_master.user_name 
      FROM user_details,user_master 
      WHERE user_master.user_id=user_details.user_id 
      AND user_details.user_status=2)

i read in a few other posts to use JOIN, but that is new to me and i have no clue how to proceed..

[dagon]

php does not run the query, the nysql server does, so the above code can't be the issue.

[Weedpacket]

And are we talking about PHP 5 versus PHP 4 or MySQL 5 versus MySQL 4?