Requête sur une date

SELECT f_manifest.date_emission, f_manifest.mode_transport, f_manifest.code_agree_consignataire, f_manifest.import_export, f_manifest.numero_sydam, f_cargo.titre_transport, f_cargo.marque_colis, f_cargo.emballage_colis, f_cargo.nature_colis, f_manifest.numero_manifeste, f_cargo.poids_colis FROM (f_manifest INNER JOIN f_cargo ON f_cargo.manifest_id=f_manifest.manifest_id) WHERE (f_manifest.date_emission BETWEEN '2009-07-01' AND '2010-01-01') GROUP BY f_manifest.date_emission, f_manifest.mode_transport, f_manifest.code_agree_consignataire, f_manifest.import_export, f_manifest.numero_sydam, f_cargo.titre_transport, f_cargo.marque_colis, f_cargo.emballage_colis, f_cargo.nature_colis, f_manifest.numero_manifeste, f_cargo.poids_colis

//Liste des Résultsets
$resDate = request("SELECT f_manifest.date_emission, f_manifest.mode_transport, [...];");

//Parcours des résultats dela requête
while($ligne = mysql_fetch_array($resDate))
{

	$date_debut   = $ligne["f_manifest.date_emission"];
        $date_fin   = $ligne["f_manifest.date_fin"];
}