Is there something wrong with this? cause it doesn't order the movies.
see
http://www.forodeherbales.com/edge/singleperson.php?personid=519&sort=new
// set the sql statement
$sqlwhere = '';
for ($i=0;$i < count($ratingsarray);$i++){
$sqlwhere = $sqlwhere . ' AND Rating_ID != ' . $ratingsarray[$i];
}
$order = 'Movies.Movie_Release_Year DESC';
$sql = "SELECT Movie_Title, Movies.Movie_ID, Front_Image_File FROM
Movies, Actor_Movie_Relationships, Rating_Movie_Relationships WHERE
Movies.Movie_ID = Actor_Movie_Relationships.Movie_ID AND Movies.Movie_ID
= Rating_Movie_Relationships.Movie_ID AND Actor_ID = ('$personid')
$sqlwhere ORDER BY $order";
Thanks
Justin Giboney
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
