I am trying to collect data from 3 tables. First I post restCity from search_city.php. That takes me to results_page.php, which has an include that calls for searchResults.php to create the table for the results. In searchResults.php it calls for searchValue.php which is a script that collects the posted field of searchValue and has an if loop statement which writes the results table based on what page the query came from, restName, restCity, or restCuisine.
What I am trying to do is take the restCity to take data from tblRestaurant which basically holds all the basic information. Then I have another include which queries the tblRestaurant to find the restID based on the city, and then use the restID to get the rest of the information from tblRestaurantFeatures. Does anyone know a good turorial that I can use to figure out this problem?
Brian