Re: [PHP] generate xls file on fly

2008-02-14 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run mysql statement again, the result might be different. to prevent this problem,

Re: [PHP] generate xls file on fly

2008-02-14 Thread Nirmalya Lahiri
--- Hiep Nguyen [EMAIL PROTECTED] wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run mysql statement again, the

Re: [PHP] generate xls file on fly

2008-02-14 Thread Andrew Ballard
On Thu, Feb 14, 2008 at 9:23 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run

Re: [PHP] generate xls file on fly

2008-02-11 Thread Daniel Brown
On Feb 11, 2008 7:41 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: any suggestion for a tutorial on session in php??? thanks. http://www.google.com/search?q=working+with+php+sessions -- /Dan Daniel P. Brown Senior Unix Geek ? while(1) { $me = $mind--; sleep(86400); } ? -- PHP General

Re: [PHP] generate xls file on fly

2008-02-11 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Jason Pruim wrote: On Feb 8, 2008, at 10:14 AM, Hiep Nguyen wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: is there anyway to generate this into xls file w/o using fopen fwrite to the server? my goal is to have a link after the table and user can

Re: [PHP] generate xls file on fly

2008-02-08 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: is there anyway to generate this into xls file w/o using fopen fwrite to the server? my goal is to have a link after the table and user can click on that link and a save window pop up to allow user to save to local disk. Yes - have

Re: [PHP] generate xls file on fly

2008-02-08 Thread Hiep Nguyen
On Fri, 8 Feb 2008, Jason Pruim wrote: On Feb 8, 2008, at 10:14 AM, Hiep Nguyen wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: is there anyway to generate this into xls file w/o using fopen fwrite to the server? my goal is to have a link after the table and user can

Re: [PHP] generate xls file on fly

2008-02-08 Thread Andrew Ballard
On Feb 8, 2008 10:14 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: is there anyway to generate this into xls file w/o using fopen fwrite to the server? my goal is to have a link after the table and user can click on that link and a

Re: [PHP] generate xls file on fly

2008-02-08 Thread Daniel Brown
On Feb 8, 2008 8:41 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi friends, i have a php page with the following logic: html head titleDownload/title /head table trtdTitle/tdtdAuthor/td/tr ? $sql = select title,author from book where title != null and author != null; ? ? $rs =

Re: [PHP] generate xls file on fly

2008-02-08 Thread Per Jessen
Hiep Nguyen wrote: is there anyway to generate this into xls file w/o using fopen fwrite to the server? my goal is to have a link after the table and user can click on that link and a save window pop up to allow user to save to local disk. Yes - have a link like this: a

Re: [PHP] generate xls file on fly

2008-02-08 Thread Adrian Bruce
Hiep Nguyen wrote: hi friends, i have a php page with the following logic: html head titleDownload/title /head table trtdTitle/tdtdAuthor/td/tr ? $sql = select title,author from book where title != null and author != null; ? ? $rs = mysql_query($sql) or die(mysql_error()); ? ?

Re: [PHP] generate xls file on fly

2008-02-08 Thread Jason Pruim
On Feb 8, 2008, at 10:14 AM, Hiep Nguyen wrote: On Fri, 8 Feb 2008, Per Jessen wrote: Hiep Nguyen wrote: is there anyway to generate this into xls file w/o using fopen fwrite to the server? my goal is to have a link after the table and user can click on that link and a save window pop

Re: [PHP] generate xls file on fly

2008-02-08 Thread Per Jessen
Hiep Nguyen wrote: let say that user searched and found 10 records, in the meantime, other users may change any of these 10 records, so if we saved mysql statement and re-run mysql statement again, the result might be different. to prevent this problem, i only want to download records that