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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| <?
//connection à la base de données
include ("connect.php");
$mysql_link = mysql_connect("$str_host","$str_user", "$str_password");
mysql_select_db("$DBASE", $mysql_link);
$secteur=$_GET['secteur'];
//requète à la base <br />
$QUERY = "select distinct bandeau from frs";
$QUERY .= " where secteur='$secteur' ";
$mysql_result = mysql_query($QUERY,$mysql_link);
while ($row = mysql_fetch_array($mysql_result))
$img =$row[bandeau];
echo '<IMG SRC="http://www.lemondedelada.com/test/img/' . $img[0] . '" BORDER = "1">';
{print" bonjour $row[rubrique]";
}
?>
<br><br>
<table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
<?
//requete de selection
$requete = "SELECT rubrique FROM frs WHERE secteur='$secteur' ORDER BY rubrique";
$QUERY .= " where secteur='$secteur' ";
$mysql_result = mysql_query($requete, $mysql_link);
while($prod = mysql_fetch_array($mysql_result))
{
$abon = $prod[abonnement];
$numero = $prod[num];
$transfert=ereg_replace(" ", "+", $prod[societe]);
if ($abon=='oui')
print("<tr>
<td bgcolor=\"#A02A8A\" align=\"center\">
<table width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
<tr>
<td bgcolor=\"#FFFFFF\" align=\"center\"><a href=\"rsecteur2.php?numero=$numero&societe=$transfert\"><div align=\"center\"><img src=\"img/$prod[logo]\" border=\"0\" align=\"center\"></div></a></td>
<td width=\"450\" bgcolor=\"#FFFFFF\"><b><a href=\"rsecteur2.php?numero=$numero&societe=$transfert\"><font size=\"3\" color=\"black\" face=\"Arial, Helvetica, sans-serif\"><div align=\"center\">$prod[rubrique]</font></div></a></b></td>
</tr>
</table>
</td>
</tr>");
else
print("<tr>
<td bgcolor=\"#A02A8A\">
<table width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
<tr>
<td bgcolor=\"#FFFFFF\"><div align=\"center\"><img src=\"img/$prod[logo]\" border=\"0\" align=\"center\"></div></td>
<td width=\"450\" bgcolor=\"#FFFFFF\"><b><font size=\"3\" color=\"black\" face=\"Arial, Helvetica, sans-serif\"><div align=\"center\">$prod[rubrique]</font></div></b></td>
</tr>
</table>
</td>
</tr>");
}
?> |
Partager