Forum

if (isset($id)) {
        $les_tutoriels = $Sql->query_while("SELECT t.id, t.user_id,t.user_login,t.titre,t.categorie,t.description,t.duree,t.difficulte,t.introduction,t.image,t.date,c.nom,c.id
        FROM " . PREFIX . "tutoriels t LEFT JOIN " . PREFIX . "tutoriels_categories c ON t.categorie = c.id WHERE t.id = ".$id." ");
        while ($row = $Sql->fetch_assoc($les_tutoriels))
      {
        $Template->assign_block_vars('tutoriels', array(
                'ID' => $row['id'],
                'USERID' => $row['user_id'],
                'USERLOGIN' => $row['user_login'],
                'TITRE' => $row['titre'],
                'CATEGORIE' => $row['nom'],
                'DESCRIPTIONTUTO' => $row['description'],
                'DUREE' => $row['duree'],
                'DIFFICULTE' => $row['difficulte'],
                'INTRODUCTION' => $row['introduction'],
                'IMAGE' => $row['image'],
                'DATE' => $row['date']
            ));
      }
    }