echo $weekTitle; ?>
LUNDI
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="lundi" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>
MARDI
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="mardi" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>
MERCREDI
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="mercredi" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>
JEUDI
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="jeudi" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>
VENDREDI
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="vendredi" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>
SAMEDI
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="samedi" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>
DIMANCHE
$sql = 'SELECT * FROM `rdv` WHERE week="'.$week.'" AND year="'.$year.'" AND dayname="dimanche" ORDER BY hourmin ASC ';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_assoc($req))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ' de '.$data['timeDeb'].' à '.$data['timeFin'].' ('.$data['day'].' '.monthNumToName($data['month']).' '.$data['year'].')'."\n";
echo ' '.$data['sujet'].''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
}
echo $separator;
?>