-- Structure de la table `arrivee`
--

CREATE TABLE IF NOT EXISTS `arrivee` (
  `Id_Arrivee` bigint(11) NOT NULL AUTO_INCREMENT,
  `Date_arrivee` varchar(25) NOT NULL,
  `num_correspondance` varchar(25) NOT NULL,
  `expediteur` varchar(25) NOT NULL,
  `objet` varchar(25) NOT NULL,
  `num_reponse` varchar(25) NOT NULL,
  `designation` varchar(25) NOT NULL,
  `observation` varchar(25) NOT NULL,
  `id_depart` bigint(11) NOT NULL,
  `id_dossier` bigint(11) NOT NULL,
  `id_fournisseur` bigint(11) NOT NULL,
  PRIMARY KEY (`Id_Arrivee`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;


-- Structure de la table `dossier`
--

CREATE TABLE IF NOT EXISTS `dossier` (
  `id_dossier` bigint(11) NOT NULL AUTO_INCREMENT,
  `num_dossier` varchar(25) NOT NULL,
  `objet` varchar(25) NOT NULL,
  `type` varchar(25) NOT NULL,
  PRIMARY KEY (`id_dossier`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

<?php
if (isset($_POST['ok'])){
require_once('Connections/connexion.php');
extract($_POST);
$req = "select * FROM arrivee where Date_arrivee like '%$rech%' " ;
$execute = mysql_query($req) or die (mysql_error()) ;
echo"<table border=0 >
<tr>
<td>Id_Arrivee</td>
<td>Date_arrivee</td>
<td>num_correspondance</td>
<td>expediteur</td>
<td>objet</td>
<td>num_reponse</td>
<td>designation</td>
<td>observation</td>
<td>id_dossier</td>
<td>id_destinataire</td>
<td>id_fournisseur</td>
</tr>";
while($ligne=mysql_fetch_array($execute)){
echo"<tr>
<td>".$ligne['Id_Arrivee']."</td>
<td>".$ligne['Date_arrivee']."</td>
<td>".$ligne['num_correspondance']."</td>
<td>".$ligne['expediteur']."</td>
<td>".$ligne['objet']."</td>
<td>".$ligne['num_reponse']."</td>
<td>".$ligne['designation']."</td>
<td>".$ligne['observation']."</td>
<td>".$ligne['id_dossier']."</td>
<td>".$ligne['id_destinataire']."</td>
<td>".$ligne['id_fournisseur']."</td>
</tr>";
}
echo"</table>";
}
?>

$sql = "SELECT * FROM `arrivee` JOIN `dossier` ON `dossier`.`id_dossier` = `arrivee`.`id_dossier` WHERE `arrivee`.`Date_arrivee` = '%".$rech."%'";

SELECT dossier.nom_dossier, 
             arrivee.date_arrivee
FROM dossier, arrivee
WHERE dossier.id_dossier = rrivee.id_dossier;