[Resolved] Query two tables error

janey

I have two tables that I am trying to query with no luck.

Tableone contains the columns: region and City
Tabletwo contains the columns: last_name and City

I would like to create a query based on region that will display corresponding last names. For example, I would query table one for "region A", and then query table two for last names that have cities belonging to "region A". Hope that makes sense.

The query I tried was:

$query = "SELECT * FROM Tableone, Tabletwo WHERE (region = '$region') and (Tableone.City = Tabletwo.City)";

Unfortunately, I get the error:

Error in query: SELECT * FROM Tableone, Tabletwo WHERE (region = '') and (Tableone.City = Tabletwo.City). Column: 'region' in where clause is ambiguous

Help!!

benkillin

you do have mysql_query( right?

janey

Hi, yes...here is more of the code:

<?
mysql_select_db($db) or die ("Unable to select database!");
$query = "SELECT * FROM Tableone, Tabletwo WHERE (region = '$region') and (Tableone.City = Tabletwo.City)";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if (mysql_num_rows($result) > 0)
{
  while($row = mysql_fetch_object($result))
  { ?>      

<? echo $row->last_name; ?>

Again, region is a field in Tableone while last_name is a field in Tabletwo. Both tables contain the field City. So, I want to query for a region and have the last names of the folks who belong to that region display (by looking at what city they are in and what region that city belongs to).

Thanks!!

janey

Think I've got this one figured out. I just needed to identify the table for "regions".

Thanks for your help.