Extraire le jour de la semaind'une date mysql

<?php
$date = "2001-09-03 22:10";
$prefix = "Le ";
$suffix = " à";
$tab_month = array(1=>"Janvier", "Fevrier", "Mars", "Avril", "Mai", "Juin", "Juillet", "Aout", "Septembre", "Octobre", "Novembre", "Decembre");
$tab_day = array("Dimanche", "Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi");
$tab_date = explode(' ', $date);
$date_hour = explode(':', $tab_date[1]);
$tab_dmy = explode('-', $tab_date[0]);
$day = date("w", mktime(0, 0, 0, $tab_dmy[1], $tab_dmy[2], $tab_dmy[0]));
$date = $prefix . "$tab_day[$day] " . "$tab_dmy[2] ";
settype($tab_dmy[1], integer);
$date .= $tab_month[$tab_dmy[1]] . " $tab_dmy[0]" . $suffix . " $date_hour[0]h " . "$date_hour[1]min";
?>