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

#review#

Starring #star1#, #star2#, #star3#
Rating #rating#
Director #director#
Category #catname#

Notable Movies with #movie.star1#:
   #title# (#year#)
<<< Movie Guide Home