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. 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 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! Link to comment https://forums.phpfreaks.com/topic/90353-help-database-tables-joining/#findComment-463265 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.