Re: Column 'movie_type_id' in order clause is ambiguous

What part of "This is a PHP list" and "This is not a mysql list" do you not understand? *TRY A MYSQL MAILINGLIST, or RTFM (mysql manual in this case)* Mark Sargent wrote:

Hi All, I get this, Column 'movie_type_id' in order clause is ambiguous for this code, $query = "SELECT movie.movie_name, movietypes.movie_type_label FROM movie, movietypes WHERE movie.movie_type_id = movietypes.movie_type_id AND movie_year>1990 ORDER BY movie_type_id"; $results=mysql_query($query) or die(mysql_error()); and here is the table structure, mysql> SELECT * FROM movie; +----------+----------------+---------------+------------+---------------------+-------------------+

| movie_id | movie_name     | movie_type_id | movie_year | movie_lead_actor_id | movie_director_id |
+----------+----------------+---------------+------------+---------------------+-------------------+ 
|        1 | Bruce Almighty |             5 |       2003 |                   1 |                 2 |
|        2 | Office Space   |             5 |       1999 |                   5 |                 6 |
|        3 | Grand Canyon   |             2 |       1991 |                   4 |                 3 |
+----------+----------------+---------------+------------+---------------------+-------------------+ 

3 rows in set (0.00 sec) mysql> SELECT * FROM movietypes; +---------------+------------------+ | movie_type_id | movie_type_label | +---------------+------------------+

|             1 | Sci Fi           |
|             2 | Drama            |
|             3 | Adventure        |
|             4 | War              |
|             5 | Comedy           |
|             6 | Horror           |
|             7 | Action           |
|             8 | Kids             |

+---------------+------------------+ 8 rows in set (0.00 sec) A Google search for the error gave nothing. Cheers. Mark Sargent.