[UPHPU] MySQL query problem
Justin Giboney
giboney at giboneydesigns.com
Sat Dec 22 18:26:52 MST 2007
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
More information about the UPHPU
mailing list