select m.*, c.name as CatName from movies m, moviecats c where movie_id=#movie_id# and m.category=c.mcat_idselect * from movies where (star1='#movie.star1#' or star3='#movie.star1#' or star2='#movie.star1#') and movie_id <> #movie_id# order by year descBullz-eye.com - Guy's Portal to the Web