RE: [PHP-DB] Shrinking gifs.

2005-06-22 Thread nikos
Thank you Martin I install new gd, reconfigure php and now is running OK. But, it was a mass to realize that shortening gifs results to loss transparency(!). So I turn them all to jpegs and use the ImageCreateFromJPG instead. My code looks like this: ? $ph='photos/'.$photo;

[PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

2005-06-22 Thread Vince LaMonica
I wanted to clarify my question from yesterday, as re-reading it, it sounds quite confusing. I have a CVS file that has order header *and* line item info on each line, like: 1110,6/20/2005,Jan Doe,123 Main St,,1,Book 1116,6/22/2005,Jim Smith,44 Here St,19191980,1,CD 1116,6/22/2005,Jim

Re: [PHP-DB] select * from table where column 'CONTAINS' more than one value (how?)

2005-06-22 Thread Dan Fulbright
I have no problem creating a table, using a query from my dbase table news: SELECT * FROM table where column = VALUE. However, now that most of our articles have more than one column type (i.e. instead of just technology, the column can now contain technology, politics, local. You need

Re: [PHP-DB] Shrinking gifs.

2005-06-22 Thread Nadim Attari
nikos a écrit dans le message But, it was a mass to realize that shortening gifs results to loss transparency(!). Yea TRUE ! The background is black ! You will get the same result when creating PNG thumbnails ! In fact imagecreate and imagecreatetruecolor both [quoted from the manual] ...

[PHP-DB] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992

2005-06-22 Thread Cosman CUSCHIERI
I make part of a team where we have created a system which produces reports. The reports are produced based on selection criteria which the user sets from an oracle database. The problem we are facing is that when the users selects a big time frame the report just freezes, the status bar

Re: [PHP-DB] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992. .

2005-06-22 Thread Martin Norland
Cosman CUSCHIERI wrote: I make part of a team where we have created a system which produces reports. The reports are produced based on selection criteria which the user sets from an oracle database. The problem we are facing is that when the users selects a big time frame the report just

RE: [PHP-DB] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992

2005-06-22 Thread Bastien Koert
once solution might be to fork a process and send that to run the sql with some big time out limit on it...then create the report save it as a file and email to the user when complete see http://ca.php.net/manual/en/function.pcntl-fork.php Bastien From: Cosman CUSCHIERI [EMAIL PROTECTED]

Re: [PHP-DB] Shrinking gifs.. .

2005-06-22 Thread Martin Norland
nikos wrote: Thank you Martin I install new gd, reconfigure php and now is running OK. But, it was a mass to realize that shortening gifs results to loss transparency(!). [snip] imagecolortransparent() That function will set the transparent color in an image (only one per image). If you

[PHP-DB] Subject: RE: [FIX YOUR SUBJECT !] php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992

2005-06-22 Thread Neil Smith [MVP, Digital media]
Hi - Suggestions : 1) Turn on error_reporting in your PHP script : ?php error_reporting(E_ALL); ? 2) Load page, and go to browser's View-Source menu, to see if you actually got malformed HTML or anything at all. Cheers - Neil From: Cosman CUSCHIERI [EMAIL PROTECTED] To:

Re: [PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

2005-06-22 Thread Doug Hernandez
On 6/22/05, Doug Hernandez [EMAIL PROTECTED] wrote: I can't help but wonder why you're using the line_order field at all. Can't you nix it and count the number of records with each order# as a stored procedure or some such? It would make your entire order system easier. Also, you may think

Re: [PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

2005-06-22 Thread Doug Hernandez
I can't help but wonder why you're using the line_order field at all. Can't you nix it and count the number of records with each order# as a stored procedure or some such? It would make your entire order system easier. Also, you may think about capturing that first row in its own list: $fp =

[PHP-DB] mysql_connect() with a multi-file format

2005-06-22 Thread Doug Hernandez
I'm new to PHP, due to having been all hard-nosed and obtuse about using Perl/CGI. I've been looking for a good way to pick up php tricks and what-nots, so I joined the list. That said, I have an immediate question. I have a multi-file script: main.php requires_once config.php, and so on. I'd

Re: [PHP-DB] mysql_connect() with a multi-file format

2005-06-22 Thread Chris Ramsay
I read in the php.net manual that the connection closes automatically when the script exits. Does this mean I can't open a db connection in one file and pass the link around from function to function? No, the script you include becomes part of the main script calling the inclusion, therefore

Re: [PHP-DB] select * from table where column 'CONTAINS' more than one value (how?)

2005-06-22 Thread Micah Stevens
On Tuesday 21 June 2005 10:35 pm, Dan Fulbright wrote: I have no problem creating a table, using a query from my dbase table news: SELECT * FROM table where column = VALUE. However, now that most of our articles have more than one column type (i.e. instead of just technology, the