mysql_connect('kaessfrgicdoss.mysql.db', 'kaessfrgicdoss', 'Eryneaston5'); mysql_select_db('kaessfrgicdoss'); $auj = strtotime(date("Y-m-d H:i:s")); $today = date("Y-m-d"); $site=$_SERVER['HTTP_HOST'];; ///////////////////////////////// //PUB accueil lacentrale ///////////////////////////////// $credit_pub_index=""; // IOBNET $var_1 ="and B.pub_url_rac_loc_regie='' and B.pub_url_rac_pro_regie=''"; $var_2 ="and (B.pub_url_rac_loc_regie<>'' or B.pub_url_rac_pro_regie<>'')"; $sql_iobnet = mysql_query("SELECT * FROM `p_ann` A, `p_ban` B, `p_pub` P, `iobsp_courtiers` I where A.user_id=I.user_id and A.ann_id=B.ann_id and B.ban_id=P.ban_id $var_1 and P.date_e<='$auj' and P.date_s>='$auj' order by RAND()");$hdnb4=mysql_num_rows($sql_iobnet);while($lm_iobnet = mysql_fetch_assoc($sql_iobnet)) { $pub_id= $lm_iobnet['pub_id']; $pub_url= $lm_iobnet['pub_url']; $credit_pub_index .= '
';} // REGIE $sql_regies = mysql_query("SELECT * FROM `p_ann` A, `p_ban` B, `p_pub` P, `iobsp_courtiers` I where A.user_id=I.user_id and A.ann_id=B.ann_id and B.ban_id=P.ban_id $var_2 and P.date_e<='$auj' and P.date_s>='$auj' order by RAND()");$hdnb4=mysql_num_rows($sql_regies);while($lm_regies = mysql_fetch_assoc($sql_regies)) { $pub_id= $lm_regies['pub_id']; $logo_id= $lm_regies['pub_logo_rac_loc_regie']; $url_id= $lm_regies['pub_url_rac_loc_regie']; if ($logo_id<>"" and $url_id<>""){$credit_pub_index .= '';}} echo $credit_pub_index; ?>