include("includes/connect.php");
include("includes/inc_fonctions.inc");
include("mo_boutique/inc_variables.php");
// on va chercher l'intitulé du theme / rubrique
$req_title_page="select news_titre, news_complet, news_ref,news_assoc_1,news_assoc_2,news_assoc_3, news_etat, marque_id , ".$nom_table."_news_news.news_id, ".$nom_table."_news_theme.theme_lib, ".$nom_table."_news_theme.theme_id, rubrique_lib,".$nom_table."_news_rubrique.rubrique_id
from ".$nom_table."_news_theme,".$nom_table."_news_rubrique, ".$nom_table."_news_news, ".$nom_table."_correspondance_themes
where ".$nom_table."_news_theme.rubrique_id=".$nom_table."_news_rubrique.rubrique_id and ".$nom_table."_correspondance_themes.news_id=".$nom_table."_news_news.news_id and ".$nom_table."_correspondance_themes.theme_id=".$nom_table."_news_theme.theme_id
and ".$nom_table."_news_theme.zone_id=1 and news_etat!='sorti' and news_etat!='archive'
and ".$nom_table."_news_news.news_id=".$_GET['news_id']." group by ".$nom_table."_news_news.news_id";
//echo $req_title_page;
$result_title_page=mysql_query($req_title_page);
$nb_result_title_page=@mysql_num_rows($result_title_page);
//if($nb_result_title_page!=1){header("location:/");}
$rubrique_id=mysql_result($result_title_page,0,'rubrique_id');
$theme_id=mysql_result($result_title_page,0,'theme_id');
$rubrique_lib_title=mysql_result($result_title_page,0,'rubrique_lib');
$theme_lib_title=mysql_result($result_title_page,0,'theme_lib');
$news_ref=mysql_result($result_title_page,0,'news_ref');
$news_etat=mysql_result($result_title_page,0,'news_etat');
$news_titre=mysql_result($result_title_page,0,'news_titre');
//$news_complet=eregi_replace('\n','
',mysql_result($result_title_page,0,'news_complet'));
$news_complet=mysql_result($result_title_page,0,'news_complet');
$news_complet=str_replace("\\n", "
",$news_complet);
$news_assoc_1=mysql_result($result_title_page,0,'news_assoc_1');
$news_assoc_2=mysql_result($result_title_page,0,'news_assoc_2');
$news_assoc_3=mysql_result($result_title_page,0,'news_assoc_3');
$marque_id=mysql_result($result_title_page,0,'marque_id');
$rewriting_rubrique=rewrite_var($rubrique_lib_title);
$rewriting_theme=rewrite_var($theme_lib_title);
?>
echo $rubrique_lib_title; ?> / echo $theme_lib_title; ?> / echo $news_titre; ?>
echo $news_titre; ?> if (news_ref!=""){ ?>[REF echo $news_ref; ?>] } ?>
if($declinaison_prix_min>0){ ?>echo $declinaison_prix_min; ?> € TTC
} ?> echo $news_complet; ?> $req_declinaison_ob="select * from boutique_news_declinaison where news_id='$news_declinaison' order by declinaison_prix"; // echo $req_declinaison_ob; $result_declinaison_ob=mysql_query($req_declinaison_ob); $nb_declinaison_ob=mysql_num_rows($result_declinaison_ob); if($nb_declinaison_ob>0){ while($rows_declinaison_ob=mysql_fetch_array($result_declinaison_ob)){ ?>} } ?>