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
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
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
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
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
5 matches
Mail list logo