Figure 3-2 You (Web site development) can get information from more
Figure 3-2 You can get information from more than one table in two ways: . Reference the individual tables in your query and link them temporarily through a common field . Formally JOIN the individual tables in your query Let s try out these methods and then talk about each of them in more detail. Referencing Two Tables You can distinguish between two tables in your database by referencing them in the SELECT statement as follows: $query = SELECT customers.name, orders.order_total FROM customers, orders WHERE customers.cust_ID = orders.cust_ID ; //retrieves customers names from customers table and order_total from //orders table where the cust_ID field in the customers table equals the //cust_ID field in the orders table. 105 Using PHP5 with MySQL
Note: If you are looking for high quality webhost to host and run your jsp application check Vision christian web host services