Results 1 to 5 of 5
Aug 31, 2013, 02:42 #1
- Join Date
- Jul 2013
- South of the equator, then turn left
- 0 Post(s)
- 0 Thread(s)
How to organize MySQL table and retrieve specific records
I have some questions about how to design my table. My website will be a directory of top restaurants in the world. I'm going to have city-specific pages that will list the restaurants in that city. So, I could have a page with 10 restaurants in Paris. Each listing includes a link to that restaurant's own page which provides more information about that restaurant.
Should I have one huge table with all of the restaurants, with for example, 5000 rows or have city-specific tables. If I use the former, how would I code my select queries to extract the city-specific rows? The latter would probably be pushing it, but from an organizational standpoint it would be nice to have a table with just the info for that city.
Could someone please give me some pointers?
Thank you in advance!