mysql query and version problem .... Help!

[Gregory Machin]

Hi.

I have just found out that my hosting provider is using mysql 4 and I'm
using mysql 5 the one query I need wont work and is a key feature in the
application .. here is the query i'm using

SELECT dealer_id, auto_id, bid_amount FROM bids b1 WHERE bid_amount=(SELECT
MAX(b2.bid_amount)
FROM bids b2 WHERE b1.auto_id = b2.auto_id) AND auto_dealer_id = '3' AND
Bid_Status = '1';

How do I get this to work on version 4 ?
Many thanks
--
Gregory Machin
[e-mail]
gregory.machin@stripped
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)

[phone]