[PHP] Re: Complex MySQL query for lowest price

2013-01-31 Thread Jim Giner
On 1/31/2013 2:21 PM, Angela Barone wrote: Hello, I have a formula that says, if 'specialprice' is not empty and it is lower than 'unitprice', use 'specialprice', otherwise use 'unitprice': Your Price: $%s', number_format(mysql_result($result,0,"used_price"),2)); ?> What I'd

[PHP] Re: Complex mysql query

2001-03-29 Thread Robert Vetter
> Yann Larrivée wrote: > > Thanks for the answer but it is a bit more complexe, i actually > creates these sample table for the example. Here is an attachement of > the structure dump. > > Hummm you got me to think more about my database structure withc is > really good. The idea you bourght u