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?


Other examples,

Thanks Everyone!