subject:"\[PHP\-DB\] MySQL\: getting latest record"

Re: [PHP-DB] MySQL: getting latest record

2003-12-14 Thread jeffrey_n_Dyke

ondon.com> cc: Subject: [PHP-DB] MySQL: getting latest record

[PHP-DB] MySQL: getting latest record

2003-12-14 Thread ShortStay

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 timestam