Nat Posted May 5, 2007 Share Posted May 5, 2007 Hi, Let's say I have a database created in MySQL containing 2 different tables. For instance table 1 is called people and table 2 is called interests. I know how to retrieve a query when there's one table from a database, for instance: // Define a query that retrieves the names $query = "SELECT first_name, last_name FROM people"; However, what do I do when I want to get the info. from 2 different tables. I'm doing what's below but this isn't working. Any advice or direction would be greatly appreciated. // Run the query and store the result $result = mysqli_query($link, $query); // Define a query that retrieves the names and interest $query = "SELECT first_name, last_name FROM people, AND sport, hobby FROM interests"; // Run the query and store the result $result = mysqli_query($link, $query); Quote Link to comment Share on other sites More sharing options...
tauchai83 Posted May 5, 2007 Share Posted May 5, 2007 <?php $sql="SELECT A.first_name, A.last_name, B.hobby FROM people A, interest B WHERE condition....."; ?> you lack tutorial. You may use INNER JOIN as well. Quote Link to comment Share on other sites More sharing options...
Nat Posted May 5, 2007 Author Share Posted May 5, 2007 I finally worked it out. $query = "SELECT first_name, last_name, sport, hobby FROM people, interests"; Thanks. Quote Link to comment 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.