[PHP-DB] Web Printing

2005-03-31 Thread Ng Hwee Hwee
Hi all, i am very perplexed now and i hope you guys can help me. i am reading 50,000 records from mySQL database and i need to print them out in a report format. However, i also need to print a page number through PHP on all the pages (for example, "Page 1 of 200") and display a header and a fo

[suspicious - maybe spam] [PHP-DB] [suspicious - maybe spam] RE: [PHP-DB] Web Printing

2005-03-31 Thread Bastien Koert
Use a pdf format...far more control see www.fpdf.org Bastien From: "Ng Hwee Hwee" <[EMAIL PROTECTED]> To: "PHP DB List" Subject: [PHP-DB] Web Printing Date: Thu, 31 Mar 2005 18:24:41 +0800 Hi all, i am very perplexed now and i hope you guys can help me. i am reading 50,000 records from mySQL datab

[PHP-DB] Why does this code/query hang & time out ?

2005-03-31 Thread -{ Rene Brehmer }-
Hi gang My CPU database (http://metalbunny.net/computers/cpudb.php) - still a work in progress - used to be in 1 table, but for several reasons I've decided it's better to split the data into multiple related tables. Obviously this means I have to rewrite the query tool for it, and that's where

Re: [PHP-DB] OCI ignoring NLS_DATE_FORMAT parameter

2005-03-31 Thread Christopher Jones
Doug McMaster wrote: Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select statement DATE fields are returned in the Oracle default DD-MON-RR format. I can successfully set NLS_DATE_FORMAT using either an environment variable and restarting apache or by using ALTER SESSION SE

Re: [PHP-DB] ocilogon timeout

2005-03-31 Thread Christopher Jones
Juffermans, Jos wrote: Hi, Some of our scripts that generate customer-facing pages, need a connection to a database. The problems is that the database is in Norway and - allthough we have a VPN setup - the connection isn't always available. In case the connection cannot be made, we can redirect

[PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Ng Hwee Hwee
hi all, thanx for all your suggestions. however, the css below doesn't seem to help me solve my problem. if my is pretty short, the will still NOT appear at the bottom of my page but it appears where my ends (which sometimes ends in the middle of my page). what else can i do?? by the way, i c

Re: [PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Mark Cain
Let me encourage you to be open minded about the use of dynamic PDF generation. Don't think PDF as in storage and downloading -- think PDF in the realm of format control. google class.ezpdf.php or just use this link: http://www.google.com/search?hl=en&q=class.ezpdf.php&spell=1 Mark Cain

[suspicious - maybe spam] [PHP-DB] [suspicious - maybe spam] PostgreSQL Backup Script

2005-03-31 Thread Vishal Kashyap @ [SaiHertz]
Dear all, I am stuck with database backup. While using pg_dump the utility asks for password but since I require this process to be automated the password prompt is giving me headaches is their any way by which can pass the password automatically. Like setting up a variable in php which passes th

Re: [PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Ng Hwee Hwee
hi! thanks for the suggestion.. actually i have tried PDF generation before and because my clients are japanese companies, the japanese characters don't get generated correctly.. i am still working on that but it doesn't seem that easy for me. furthermore, i really still can't see how PDF allows

RE: [PHP-DB] Why does this code/query hang & time out ?

2005-03-31 Thread Juffermans, Jos
i Rene, So far, I have found a few mistakes in your SQL: $query .= " OR `variant` LIKE '%".$_GET['search']."%'"; Why do you have backtick-quotes around variant? Know that backticks are used to call system commands. You also use these backticks in the ORDER BY lines. My guess is the backti