Justin Giboney wrote:
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"
I think you need "where $sqlwhere"
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
