[APuppyDog]

hi wirehopper, thanks for your feedback. I tried .php5 (hosted with godaddy) and even though they have php5 installed, it didn't seem to work for me.

as for rewriting it.. i found a solution online but not sure how to apply it to my code..

here is what i found:

the code was

Code:

SELECT books.idbook, books.title 
FROM books
WHERE EXISTS (SELECT * FROM out_of_stock WHERE out_of_stock.city =  'london' 
AND out_of_stock.idbook = books.idbook)

Code:

SELECT books.idbook, books.title
FROM books LEFT OUTER JOIN out_of_stock
ON out_of_stock.city = 'london'
AND books.idbook = out_of_stock.idbook
WHERE out_of_stock.idbook IS NULL;

now i need to know how to get

Code:

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)

to the way they wrote it in the second set of codes..