[PHP-DB] MySQL: getting latest record

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

Re: [PHP-DB] 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

[PHP-DB] Informix - help!

I have red hat linux with Apache web server and PHP. I want to connect, using PHP, to an Informix Database remotely. What is all I have to do on my side? Thanks a lot -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php mail() question

Hi, Php mail() question. I use php mail() frequently, dragging data from a mysql database. I am not sure if this is possible but thought I'd throw it on this board. in php mail() function you can set a return_address etc. Is it possible to change this and run a query? I mean if the email