问只返回1项

EN

public function getByPerma($perma, $lang=null){
    $perma = mysql_real_escape_string($perma);
    $movie = array();
    $e = mysql_query("SELECT * FROM movies WHERE perma='$perma'") or die(mysql_error());
    if (mysql_num_rows($e)>0){
        $movie = $this->formatMovieData(mysql_fetch_assoc($e), $lang);
    }
    return $movie;
}

public function getMovieCategoryDetails($movieid,$lang=null){
    $movieid = mysql_real_escape_string($movieid);
    $e = mysql_query("SELECT * FROM movie_tags WHERE id IN (SELECT tag_id FROM movie_tags_join WHERE movie_id=$movieid)") or die(mysql_error());
    $tags = array();
    if (mysql_num_rows($e)){
        while($s = mysql_fetch_array($e)){
            $s['tag'] = json_decode($s['tag'],true);
            if ($lang){
                $s['tag'] = $s['tag'][$lang];
            }

            $tags[$s['id']] = $s;
        }
    }
    return $tags;
}

$movies = $movie->getByPerma($perma,$language);
if (empty($movies)) {
    $movies = '';
} else {

    $tags = $movie->getMovieCategoryDetails($movies['id'],$language);
    if (!count($tags)){
        $smarty->assign("tags","");
    } else {
        $smarty->assign("tags",$tags);
    }
} 

{foreach from=$tags key=id item=val name=tags}
    {$val.tag}
{/foreach}