Comment afficher des variable issu de jointure

<?php
$reponse = mysql_query('
SELECT news.id AS news_id,
news.posteur,
news.contenu,
news.date,
news.accepter,
news.titre,
inscrit.id AS inscrit_id,
inscrit.pseudo
FROM news
LEFT JOIN inscrit
ON news.posteur = inscrit.id
WHERE accepter = "oui"
ORDER BY news.id DESC') or die(mysql_error());
while ($news = mysql_fetch_array($reponse) )
{
echo '<div id="liste-news">';
echo '<h3 class="news" id="n25021">';
echo $news['titre'];
echo '</h3>';
?><div class="auteur_date_commentaires"><a href="#">#</a> Par <a href="profil.php?id=<?php
echo $news['inscrit_id'];
?>"><?php
echo $news['pseudo'];
echo '</a>, le ';
echo $news['date'];
echo '</div><div class="contenu_news">';
$bb = $news['contenu'];
$bb = preg_replace('#\[url\](.+)\[/url\]#i', '<a href="$1">$1</a>', $bb);
$bb = preg_replace('#\[img\](.+)\[/img\]#i', '<img src="$1">', $bb);
$bb = preg_replace('#\[center\](.+)\[/center\]#i', '<center>$1</center>', $bb);
$bb = preg_replace('#\[b\](.+)\[/b\]#i', '<b>$1</b>', $bb);
$bb = preg_replace('#\[i\](.+)\[/i\]#i', '<i>$1</i>', $bb);
$bb = preg_replace('#\[u\](.+)\[/u\]#i', '<u>$1</u>', $bb);
$bb = preg_replace('#\[barre\](.+)\[/barre\]#i', '<del>$1</del>', $bb);
$bb = preg_replace('#:soleil:#', '<IMG SRC="image/soleil.png">', $bb);
$bb = preg_replace('#:l:#', '<IMG SRC="image/langue.png">', $bb);
$bb = preg_replace('#:lol:#', '<IMG SRC="image/rire.png">', $bb);
$bb = preg_replace('#:waw:#', '<IMG SRC="image/waw.png">', $bb);
$bb = preg_replace('#:siffle:#', '<IMG SRC="image/siffle.png">', $bb);
$bb = preg_replace('#:angry:#', '<IMG SRC="image/angry.gif">', $bb);
$bb = preg_replace('#:blink:#', '<IMG SRC="image/blink.gif">', $bb);
$bb = preg_replace('#:clin:#', '<IMG SRC="image/clin.png">', $bb);
$bb = preg_replace('#:heureux:#', '<IMG SRC="image/heureux.png">', $bb);
$bb = preg_replace('#:hihi:#', '<IMG SRC="image/hihi.png">', $bb);
$bb = preg_replace('#:huh:#', '<IMG SRC="image/huh.png">', $bb);
$bb = preg_replace('#:mechant:#', '<IMG SRC="image/mechant.png">', $bb);
$bb = preg_replace('#:pinch:#', '<IMG SRC="image/pinch.png">', $bb);
$bb = preg_replace('#:triste:#', '<IMG SRC="image/triste.png">', $bb);
$bb = preg_replace('#:smile:#', '<IMG SRC="image/smile.png">', $bb);

$bb = nl2br($bb);
$bb=str_replace("\r\n", "<br/>", $bb);
echo $bb;

if($news['inscrit_id'] == $id_membre OR $permission == 'Admin' OR $permission == 'modo')
{
echo '<br /><a href="news.php?action=2&&news=';
echo $news['news_id'];
echo '">Modifier</a><br />';
echo '<a href="news.php?action=3&&news=';
echo $news['news_id'];
echo '">Supprimer</a>';
}
echo '</div>';
echo '</div>';
}
echo '</div>';