Old pedant.. I'm sure you know better than me, but both must be displayed.. i guess you query price, and then somehow determine MIN?
Fou-Lu.. I did get this working with your script above... but when i try to add in all of my other fields it's dying out.. and I'm certain that it's my query that's doing so.. (p.s. i was running mysql_query and trying to dump the vars... just pasted too soon and forgot to update it... sorry about that)
here are my table details fields:
I'm simply (it makes me feel worse actually that i keep saying "simply" lol) trying to dump these values into a table.. and show the minimum price available based on the 'tag', in the <tr title="The Minimum Price is: $MINPRICE on $URL"> of course i know thats not right.. but that's the idea behind it...
basically a tag will be "NYC-DEN" and i will load the table with data for NYC-DEN flights.. then if you see "NYC-DEN" you can hover the table row, and it will give you a minimum price for that route..
does that make any sense?
here is some quick sample data:
sr_city-test expedia.eu 993.385 8885.36 7.80369 BHM-MAD 2013-03-03 MAD-BHM 2013-03-10 NULL NULL 740.27 EUR 0.779177 2012-11-23 02:32:35
sr_city-test expedia.jp 900.554 8885.36 7.88436 BHM-MAD 2013-03-03 MAD-BHM 2013-03-10 NULL NULL 96360 JPY 80.4506 2012-11-23 02:32:23
sr_bhm_mad edreams.eu 998.484 8885.36 8.98651 BHM-MAD 2013-03-03 MAD-BHM 2013-03-10 NULL NULL 722.16 EUR 0.779177 2012-11-22 10:59:19
sr_bhm_mad expedia.mx 970.078 8885.36 8.66682 BHM-MAD 2013-03-03 MAD-BHM 2013-03-10NULL NULL 14040 MXN 13.0376 2012-11-22 10:26:44