Hi Everyone,

I hope this is the correct forum for this question!

I'm new to mysql/php but I've always wondered how certain websites display content on a per-location basis? I'm quite certain these websites don't write 100s or 1000s of mysql commands but I would like to know how their information is displayed.

For example, SELECT * FROM car_info WHERE state='massachusetts' The reason why I don't believe they have unique mysql commands like this is because they would have to write 1000s of commands and it would be too time consuming as a web developer to do so. My question is, how are pages like this programmed without having to write 1000s of mysql commands? How do they "show/present" content that's unique to the page and visitor?

http://cars.oodle.com/regions/massachusetts/
http://cars.oodle.com/used-cars/barnstable-ma-area/
http://cars.oodle.com/used-cars/boston-area/
http://cars.oodle.com/used-cars/pittsfield-ma-area/

Other examples,
http://www.iseecars.com/used-cars/us...hode-island-ri
http://www.iseecars.com/used-cars/us...ssachusetts-ma

Thanks Everyone!