export MySQL - Excel Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear All,
I've problem about exporting my MySQL table to excel at some field with value (e.g 30320000400021 ) in MySQL table become like 3,032E+13 in CSV or excel.
Can any one help me..i use script in header in file to export like this :
    header("Content-type: application/x-msdownload");
    header("Content-Disposition: attachment; filename=data_agen_".date("d-m-Y_H_i").".xls");
    header("Pragma: no-cache");
    header("Expires: 0");
    print $header."\n".$data;
Or is there wrong in my table structur type ?! i use type int, varchar and text but same result occured.. :(

Please some body help me..
Thanks

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux