'; $text .= ''; $text .= ''; $text .= ''; $text .= 'http://www.superpouvoir.com/'; $text .= 'Les news Panini Comics sur www.superpouvoir.com'; $annee = date("Y"); $text .= '© Superpouvoir.com '.$annee.''; $text .= 'fr'; $query = " SELECT t.forumid, n.id AS newsid, n.titre, n.texte, n.image, n.url, n.date, n.postid AS numPost, p.postid, p.threadid FROM news AS n INNER JOIN post AS p ON n.postid = p.postid INNER JOIN thread AS t ON p.threadid = t.threadid WHERE t.forumid = 50 ORDER BY n.id DESC LIMIT 30;"; $result = mysql_query($query) or die(mysql_error()); while($data = mysql_fetch_object($result)) { $text .= ''; $text .= ''; $text .= ''.$data->url.''; $text .= '<img src="'.$data->image.'" /><br/>'.$data->texte.'...'; $text .= ''.$data->date.''; $text .= ''; } $text .= ''; $text .= ''; echo $text; mysql_close(); ?>