Originally Posted by Old Pedant
Great. Now just what is it you want to display, GIVEN that sample data??
Not sure that's exactly what you want, and of course it doesn't relate all that well to the expedia data, but the point is that you can do everything in a single query.
no it's good info..
thanks.. I'm trying to basically a) dump all this into a table.. and for each <tr> tag add a Title attribute that will display the lowest price for the route that is displayed in the field "tag".. there may be 1000 "NYC-ORD" tags with different prices.. but only 1 lowest.. so when i mouseover any row with "NYC-ORD" as the tag (or whatever) it pops up the title that says "Lowest Price is $142.17 on expedia.com" (price and url are both stored, but i can do wthout the "expedia.com" as it's easily searchable in the table once you know..)
i'll try to massage this to work for my scenario.. I've been doing PL/PY/JS for a bit, and now I'm working on a front end for some of my scripts.. and dumping all the data into SQL has me learning php/sql.. so unfortunately I'm a bit of a newb and it's showing.. my apologies