1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| <?php
$dbhost="localhost";
$user="root";
$code="";
$usebdd="mcb";
// Connects to your Database
$connexion= mysql_connect ("$dbhost", "$user", "$code");
if (!$connexion)
{
echo "impossible d'effectuer la connexion";
exit;
}
//selection of database
$db=@mysql_select_db("$usebdd",$connexion);
if (!$db)
{
echo "impossible de selectionner cette base de donnees";
exit;
}
$requete= "SELECT name,surname,docname,status,date FROM `utili`,`doc` ORDER BY `date` DESC LIMIT 3 " ;
$texte= mysql_query($requete);
while ($affiche = mysql_fetch_assoc($texte))
{
echo $texte;
}
?> |