[SOLVED] Export 2 Excel

[ballouta]

Hello,

I have this code and it is working well, but I need to customize its look when i export an order.

 

My 'orders' table structure is as follows:

 

ID        orderno            member                bcode        bname        qty        price

==      ======            ======              =====        =====        ===    ====

45      159874            ballouta@me.com    DB1548      Book name    2        2.5

 

Exporting this member order with many items will make  useless columns in Excel (member and orderno) since both are the same.

 

Am I able to write the orderno in a cell in the begining of the sheet, and the member on another line, then the order detail without the member and orderno column?

 

my code is:

 

<?php


$orderno = $_GET['id'];

include('../operations.inc.php');

$query  = "SELECT * FROM `orders` where `orderno` = '$orderno'";
$result = mysql_query($query) or die('Error, query failed');

$tsv  = array();
$html = array();
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
   $tsv[]  = implode("\t", $row);
   $html[] = "<tr><td>" .implode("</td><td>", $row) .              "</td></tr>";
}

$tsv = implode("\r\n", $tsv);
$html = "<table>" . implode("\r\n", $html) . "</table>";

$fileName = 'DmcOrder.xls';
header("Content-type: application/vnd.ms-excel"); 
header("Content-Disposition: attachment; filename=$fileName");

echo $tsv;

?>

Many Thanks

[Mchl]

Just tweak your query to get the columns you want and in order you want.

[ballouta]

I know how to exclude the member and orderno coulum from query. BUT how do i write them in the begining of the excel file?

ok. i make a query and het both variables, and how do i write them in excel before the while loop?

 

thanks

[Mchl]

Find

$html = array();

 

After add:

$html[] = "<tr><td>Column1</td><td>Column2</td>....</tr>";