List:General Discussion« Previous MessageNext Message »
From:Gregory Machin Date:March 21 2006 11:28am
Subject:mysql query and version problem .... Help!
View as plain text  
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
greg@linuxpro.co.za
gregory.machin@stripped
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)

+27 72 524 8096
Thread
mysql query and version problem .... Help!Gregory Machin21 Mar
RE: mysql query and version problem .... Help!Mark Addison21 Mar
  • Re: mysql query and version problem .... Help!Gregory Machin22 Mar
    • Re: mysql query and version problem .... Help!Peter Brawley22 Mar
  • Re: mysql query and version problem .... Help!Gregory Machin22 Mar
    • Re: mysql query and version problem .... Help!Gabriel PREDA22 Mar