/* include('global.inc'); */
include('connexion.inc');
$mysql_link = mysql_connect($host,$user,$password);
mysql_select_db($base_boutique,$mysql_link) or die (" Impossible d'ouvrir la base");
/*Requete Categorie produit */
$requete_cat = "SELECT Int_Cat_Code,VC_Cat_Libelle,VC_Cat_Url,VC_Cat_Var FROM CATEGORIE order by VC_Cat_Libelle";
$resultat_cat = mysql_query($requete_cat,$mysql_link);
$nbre_rng_cat = mysql_num_rows($resultat_cat);
/*Requete Rubrique Info Pratique */
$requete_rubriqinfopratiq = "SELECT Int_RubriqInfoPratiq_Code,VC_RubriqInfoPratiq_Libelle,VC_RubriqInfoPratiq_Url FROM RUBRIQUE_INFO_PRATIQUE order by VC_RubriqInfoPratiq_Libelle";
$resultat_rubriqinfopratiq = mysql_query($requete_rubriqinfopratiq,$mysql_link);
$nbre_rng_rubriqinfopratiq = mysql_num_rows($resultat_rubriqinfopratiq);
/*Requete Rubrique Ressource*/
$requete_rubriqressource = "SELECT Int_RubriqRessource_Code,VC_RubriqRessource_Libelle,VC_RubriqRessource_Url FROM RUBRIQUE_RESSOURCE order by VC_RubriqRessource_Libelle";
$resultat_rubriqressource = mysql_query($requete_rubriqressource,$mysql_link);
$nbre_rng_rubriqressource = mysql_num_rows($resultat_rubriqressource);
/*Initilisation de variables*/
$date_du_jour = date("Y-m-d");
/*Requete Information Votre Attention*/
$requete_infovotreattention = "SELECT * FROM INFORMATION_VOTRE_ATTENTION WHERE Int_InfoVotreAtt_Date_Debut <='$date_du_jour' AND '$date_du_jour'<=Int_InfoVotreAtt_Date_Fin";
$resultat_infovotreattention = mysql_query($requete_infovotreattention,$mysql_link);
$nbre_rng_infovotreattention = mysql_num_rows($resultat_infovotreattention);
?>
|
|
|
|
|
|
|
|
|
|
|
|
Woezon
Communication©, Equipe 2002 tous droits réservés.
|
|
|
|
mysql_close($mysql_link);
?>