<?php

session_start();

//include('functions.inc.php');



//$base = mysql_connect ('localhost', 'root', ''); 

//mysql_select_db ('espace_membre', $base);

   

connecter();



//$query='SELECT * FROM messages where lu="0" AND id_destinataire="'.$_SESSION['id'].'"';

//$result=mysql_query($query);

//$num=mysql_num_rows($result);



$sql= 'SELECT count (id) as nb_mess FROM messages WHERE id="12"';

$req = mysql_query($sql) or die('Erreur SQL <br>'.$sql.'<br/>'.mysql_error());

$data = mysql_fetch_array($req);

$nombre_de_message = $data['nb_mess'];



if($nombre_de_message <= 1){

	$nombre_de_message = "$nombre_de_message nouveau message";

	//echo"Vous avez $num nouveau message";

	}

	else

	{

	$nombre_de_message = "$nombre_de_message nouveaux messages";

	//echo"Vous avez $num nouveaux messages";

	}

	mysql_close();



?>