[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