query in My SQL & PHP

[Nat]

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);

[tauchai83]

<?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.

[Nat]

I finally worked it out.

 

$query = "SELECT first_name, last_name, sport, hobby FROM people, interests";

 

Thanks.