Re: MySQL: getting latest record

you've just about got it in your question. SELECT * FROM MyTable WHERE Field1='test' OR Field2='test2' ORDER BY TIMSTAMP DESC LIMIT 1 hth Jeff "ShortStay" <john@shortstay-l To: <php-db@lists.php.net> ondon.com> cc: Subject: [PHP-DB] MySQL: getting latest record 12/14/2003 10:47 AM My application is that I am getting the latest quote for a price where more than one quote may have been made. I've got a timestamp colum and I want to get the latest record where certain columns have certain values. Eg SELECT * FROM MyTable WHERE Field1='test' ...? something about the timestamp I may also have an OR in the condition, like WHERE Field1='test1' OR Field2=test2'... 'test1' and test2' would be different products. Do I have to use ASCending or DESCending on the timestamp column and LIMIT? Never done this before so suggestions gratefully received. Thanks, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php