| |
|
|
|
|
|
| ';
/*création des étiquettes date heure lieu ...*/
echo ' | Date | ';
echo ' Heure | ';
echo ' Lieu | ';
echo ' Avec | ';
echo ' Prix | ';
echo ' '
.' | '
.' ';
$currentTimeStamp = date("Y-m-d");
$result=mysql_query("SELECT * FROM shows WHERE dateshow >= '".$currentTimeStamp."' ORDER BY dateshow ;");
if(mysql_num_rows($result)==0)
{
echo "| Aucune date prévue pour le moment | ";
}
else
{
while($rowsMaRequete=mysql_fetch_array($result))
{
$currentTimeStamp = date("Y-m-d");
if($rowsMaRequete['dateshow'] >= $currentTimeStamp)
{
$dateshow=substr($rowsMaRequete['dateshow'],8,2)."-".substr($rowsMaRequete['dateshow'],5,2)."-".substr($rowsMaRequete['dateshow'],0,4);
echo ''
.'| '.$dateshow.' | '
.''.$rowsMaRequete['heureshow'].' | '
.''.$rowsMaRequete['lieushow'].' | '
.''.$rowsMaRequete['groupesshow'].' | '
.''.$rowsMaRequete['prixshow'].' | '
.' ';
}
}
}
$resultMaRequete=mysql_query("SELECT * FROM `shows` ORDER BY dateshow DESC ;");
echo '';
echo '
Past shows : | ';
echo' ';
while($rowsMaRequete=mysql_fetch_array($resultMaRequete))
{
$currentTimeStamp = date("Y-m-d");
if($rowsMaRequete['dateshow'] < $currentTimeStamp)
{
$datepast=substr($rowsMaRequete['dateshow'],8,2)."-".substr($rowsMaRequete['dateshow'],5,2)."-".substr($rowsMaRequete['dateshow'],0,4);
echo ''
.'| '.$datepast.' | '
.''.$rowsMaRequete['heureshow'].' | '
.''.$rowsMaRequete['lieushow'].' | '
.''.$rowsMaRequete['groupesshow'].' | '
.''.$rowsMaRequete['prixshow'].' | '
.' ';
}
}
echo ' ';
?> |
|
|
