1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
<?php
$bdd = Connectbdd();
$count = $bdd->prepare("SELECT COUNT(id) AS nb FROM project_selection WHERE promo_date='".date('W')."' AND type='1' LIMIT 1");
if($count->execute() >0)
{
$select = $bdd->prepare("SELECT * FROM project_selection WHERE promo_date='".date('W')."' AND type='1' LIMIT 4");
$resultat = $select->execute();
$projet = $bdd->prepare("SELECT * FROM project WHERE id='".$resultat['id_projet']."' LIMIT 4");
echo '<span class="title sbig">La selection de la semaine</span><br />';
while($rows = $projet->execute())
{
// Contenu de ma boucle...
}
}
?> |