[PHP] Column 'movie_type_id' in order clause is ambiguous

2006-05-28 Thread Mark Sargent
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

Re: [PHP] Column 'movie_type_id' in order clause is ambiguous

2006-05-28 Thread cajbecu
Hello, Try ... ORDER BY `movie`.`movie_type_id`; 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 = mov

[PHP] Re: Column 'movie_type_id' in order clause is ambiguous

2006-05-28 Thread M. Sokolewicz
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

[PHP] Best way to save reports, comments and suggestions welcome

2006-05-28 Thread Ryan A
Hi, I have to write a kind of logging script which will keep records of how long a person used the site and its functions, so far this is what I have come up with: login_username varchar(50) as_guide <- You can ignore this,its for a special func login_time timestamp logout_time timestamp this_ses

Re: [PHP] Best way to save reports, comments and suggestions welcome

2006-05-28 Thread Robert Cummings
On Sun, 2006-05-28 at 18:49, Ryan A wrote: > Hi, > I have to write a kind of logging script which will > keep records of how long a person used the site and > its functions, so far this is what I have come up > with: > > login_username varchar(50) > as_guide <- You can ignore this,its for a specia