Re: [PHP] Complex MySQL query for lowest price

2013-02-01 Thread Angela Barone
Thank you for everyone's input. Someone suggested the MySQL list, so I posted my question there and got the answer I needed. Regards, Angela -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Complex MySQL query for lowest price

2013-01-31 Thread Stephen
While complex, this is standard SQL. But this is a PHP list :( The way to construct the statement is to use a nested select. Something like this SELECT blah with variable blah WHERE ( SELECT value within dates and assign to variable) To go further I would need to play, and I don't have the