CREATE TABLE `article` (

`NumArticle` int(6) NOT NULL auto_increment,

`NomAritcle` varchar(250) NOT NULL,

`DescrArticle` text,

`TexteArticle` text NOT NULL,

PRIMARY KEY(`NumArticle`)

) TYPE=MyISAM AUTO_INCREMENT=1;

<?

$sql = 'SELECT NumArticle,NomArticle,DescrArticle FROM article ORDER BY NomArticle ASC';



$req = mysql_query($sql) or die(mysql_error());



while($data=mysql_fetch_array($req))

{

    ?><a href="viewarticle.php?num=<? echo $data['NumArticle']; ?>"><? echo stripslashes($data['NomArticle']; ?></a><br/>

?>

echo stripslashes($data['DescrArticle']);

}

?>

<?

if(isset($_GET['num']) && !empty($_GET['num']))

{

   $sql = 'SELECT NomArticle,TextArticle FROM article WHERE NumArticle = "'.$_GET['num'].'"';

   $req = mysql_query($sql) or die("Erreur");

$article = mysql_fetch_array($req);

echo stripslashes($data['NomArticle']);

echo "<br/>".stripslashes($data['TexteArticle']);

?>