'' 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 .= '
Publicité IOBSP en rachat de crédits
';} // 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 .= '
Publicité IOBSP en rachat de crédits
';}} echo $credit_pub_index; ?>