[PHP] Re: use php to download mysql table

[M. Sokolewicz]

try:

header('Content-type: application/vnd.ms-excel');
echo '<table>';
$result = mysql_query('...');
while($row = mysql_fetch_array($queryResult)){
   echo '<tr>';
   foreach($row as $cell) {
      echo '<td>'.$cell.'</td>';
   }
   echo '</tr>';
}
echo '</table>';
exit;
?>

Amc wrote:

Hi,

Does anyone have any sample code that will download a mysql table to an
excel file?

Thanks

-----
http://www.dbtools.com.br/
-----
zerof

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php