Re: use php to download mysql table
| From: | M. Sokolewicz | Date: | Sat, 18 Sep 2004 22:28:58 +0000 |
| Subject: | Re: use php to download mysql table | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-197134@lists.php.net to get a copy of this message | ||
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