studgate Posted February 10, 2008 Share Posted February 10, 2008 Hi Guys, What I am trying to do is join multiple tables together. I have 4 tables in my database (state, city, maps, people). What I want to do is be able to get maps for a specific state, like if the stateid in the map table is equals to the name of the state, show that map, or be able to show a list of people from that state, etc. I hope that I explain myself to you. Quote Link to comment https://forums.phpfreaks.com/topic/90353-help-database-tables-joining/ Share on other sites More sharing options...
Barand Posted February 10, 2008 Share Posted February 10, 2008 see http://www.w3schools.com/sql/sql_join.asp Quote Link to comment https://forums.phpfreaks.com/topic/90353-help-database-tables-joining/#findComment-463258 Share on other sites More sharing options...
studgate Posted February 10, 2008 Author Share Posted February 10, 2008 that should help. thanks! Quote Link to comment https://forums.phpfreaks.com/topic/90353-help-database-tables-joining/#findComment-463265 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.