$query = "SELECT * FROM matable";
$result = mysql_query($query);
$results = array();
while($results[] = mysql_fetch_assoc($result)) ;
 
foreach($results as $result) {
    foreach($result as $key => $value) {
        echo "<$key>$value</$key>";
    }
}

<?php
 // Dump of a database on a server
 $sHost = 'MonServeur';
 $sDatabase = 'MaBD';
 $sLogin = 'login';
 $sPassword = 'mdp';
 $sExportPath = "/local/data/www5/DBExports/$sDatabase".'_'.date('Ymd').'.sql';
 
 $sOptions = '--opt --default-character-set=latin1';
 $sMysqldump = '/local/opt/mysql-5.0.45/bin/mysqldump';
 
 $sCmd = "$sMysqldump $sOptions $sDatabase -h $sHost -u $sLogin -p$sPassword > $sExportPath";
 
 echo "Sauvegarde de la BD <b>$sDatabase</b> dans le fichier <i>$sExportPath</i><br />\n";
 $output = shell_exec($sCmd);
 echo "<pre>$output</pre>";
 
 // Delete dumps with a date > 1 week
 $files = glob('/local/data/www5/DBExports/'.$sDatabase."_*.sql" );
 $iOneWeekDate = strtotime(date('Y-m-d', strtotime("1 week ago -1 day" )));
 echo "Date il y a 1 semaine : ".date('d/m/Y', $iOneWeekDate)."<br />\n";
 
 $ArrayFilesToDelete = array();
 foreach ($files as $filename) {
     $iFileDate = filemtime($filename);
     $sMsg = "";
     if ($iFileDate < $iOneWeekDate) {
         // The file must be deleted
         $ArrayFilesToDelete[] = $filename;
         $sMsg = " [A supprimer!]";
     }
 
     echo "$filename : ".date('d/m/Y', $iFileDate)."$sMsg<br />\n";
 }
 
 // Delete the files
 foreach($ArrayFilesToDelete as $f => $CurrentFile) {
     unlink($CurrentFile);
 }
?>