MUSIQUE & INSTRUMENTS       MUSIC & INSTRUMENTS 
   
<h3> MUSIQUE & INSTRUMENTS       MUSIC & INSTRUMENTS   </h3>

 
<table border="1" cellpadding="0" cellspacing="1">

<tr>






<th width="18%">Name</th>

<th>Publications &nbsp;</th>

<th width="10%"><center>Topic </center></th>




</tr>

<?php
// Déclaration des paramètres de connexion


$host = 'db3';

// Généralement la machine est localhost
// c'est-a-dire la machine sur laquelle le script est hébergé

$user = 'mathart';

$bdd = 'mathart';

$passwd = 'n.ktG%';



?>


<?php
// Connexion au serveur
mysql_connect($host, $user, $passwd) or die("erreur de connexion au serveur");
mysql_set_charset ('UTF8');
mysql_select_db($bdd) or die("erreur de connexion a la base de donnees");
?>
<?php

// Creation et envoi de la requete
$query = "SELECT authors.name, authors_publications.publications, authors_publications.links,authors_publications.bibliography, authors_publications.topic FROM authors, authors_publications WHERE ((authors_publications.Id_authors = authors.Id)AND (authors_publications.topic ='MI')) ORDER BY name ";
$result = mysql_query($query);

?>

<?php
// Recuperation des resultats

$nombre_de_lignes = 1;

If($result)
{
while($row = mysql_fetch_row($result))
{


$name = $row[0]; $name=htmlspecialchars($name);

$publications = $row[1]; $publications = htmlspecialchars($publications); 

$links = $row[2]; $links = htmlspecialchars($links); 

$bibliography = $row[3]; $bibliography = htmlspecialchars($bibliography); 

$topic = $row[4]; $topic = htmlspecialchars($topic); 


If($links != '')


	 {echo 


 

 "<tr>\n
<td>$name &nbsp;</td>\n
<td><a href=\"$links\"><i>$publications</i></a>. 
 &nbsp; $bibliography
 </td>\n

<td width =\"10%\"> &nbsp;&nbsp;&nbsp; $topic </td>\n


</tr>\n";
	 }
	 
	else

{echo


 "<tr>\n
<td>$name &nbsp;</td>\n

 <td><i>$publications</i>. 
 
 &nbsp; $bibliography</td>\n
 
<td width = \"10%\">&nbsp;&nbsp;&nbsp; $topic </td>\n
</tr>\n";
 
	 
	 
$nombre_de_lignes++;

}
}
}
?>



</table>