messagerie

<?php

session_start();

if (!isset($_SESSION['mail'])) {

    header ('Location: index.php');

    exit();

}		





		 	$base = mysql_connect ('localhost', 'login', 'pass'); 

            mysql_select_db ('db_D_boostrafic_com', $base);



   

        $sql = 'SELECT * FROM membre WHERE mail = "'.$_SESSION['mail'].'"';

        $req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());

        $data = mysql_fetch_array($req);

		

		$m = 'SELECT * FROM message WHERE iddest = "'.$data['id'].'"';

        $mes = mysql_query($m) or die('Erreur SQL !'.$m.''.mysql_error());

		while ($mess = mysql_fetch_array($mes)) {

        // on affiche les résultats

        echo 'message de : '.$mess['prenom'].'envoyé le : '.$mess['date'].'à : '.$mess['heure'].'<br>'.$mess['message'].'<br><br><font color="#FF9900">_________________</font><br><br>';



		}



?>