[PHP-DB] Re: [EMAIL PROTECTED] php crashes with msyql

2006-03-21 Thread William A. Rowe, Jr.
Noah Silverman wrote: Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. You don't enable zts so I seriously doubt your php is threadsafe; you configure httpd without speci

Re: [PHP-DB] php crashes with msyql

2006-03-21 Thread Chris
Noah Silverman wrote: Yes, Same versions.. Hmm. I'm out of ideas :( Might need to post on the -internals list and see if one of the developers can help you with the backtrace. On Mar 21, 2006, at 5:58 PM, Chris wrote: Noah Silverman wrote: Chris, Thanks in advance for all the help.

Re: [PHP-DB] php crashes with msyql

2006-03-21 Thread Noah Silverman
Yes, Same versions.. -N On Mar 21, 2006, at 5:58 PM, Chris wrote: Noah Silverman wrote: Chris, Thanks in advance for all the help. i appreciate it. The script - -- The error from apache log - [Tue Mar 21 15:3

[PHP-DB] php crashes with msyql

2006-03-21 Thread Noah Silverman
Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. Thanks, -N -- The issue: when I load a php file in a browser that references mysql, it crashes the a

Re: [PHP-DB] Proper procedure to close mysql queries!

2006-03-21 Thread JeRRy
Thanks :) Chris <[EMAIL PROTECTED]> wrote: JeRRy wrote: > Hi Chris, > > Thanks for that, always wondered. So what does just using '?>' do than? > > Must close eventually but I am guessing by using that as a close the > connection times out after a set period of time and the 'pid' is killed, >

Re: [PHP-DB] Proper procedure to close mysql queries!

2006-03-21 Thread Chris
JeRRy wrote: Hi Chris, Thanks for that, always wondered. So what does just using '?>' do than? Must close eventually but I am guessing by using that as a close the connection times out after a set period of time and the 'pid' is killed, correct? If you're using mysql_connect php will clo

Re: [PHP-DB] Proper procedure to close mysql queries!

2006-03-21 Thread JeRRy
Hi Chris, Thanks for that, always wondered. So what does just using '?>' do than? Must close eventually but I am guessing by using that as a close the connection times out after a set period of time and the 'pid' is killed, correct? J ---chris said--- m

Re: [PHP-DB] Proper procedure to close mysql queries!

2006-03-21 Thread Chris
JeRRy wrote: Hi, Just need some mailing list input here, what is the proper way to close a mysql query using PHP. - What is the proper way to close a php query to mysql if one query is in the file? - What is the proper way to close a php query to mysql if 2 or more queries is in t

[PHP-DB] Proper procedure to close mysql queries!

2006-03-21 Thread JeRRy
Hi, Just need some mailing list input here, what is the proper way to close a mysql query using PHP. - What is the proper way to close a php query to mysql if one query is in the file? - What is the proper way to close a php query to mysql if 2 or more queries is in the file and wh

Re: [PHP-DB] php crashes with msyql

2006-03-21 Thread Chris
Noah Silverman wrote: Chris, Thanks in advance for all the help. i appreciate it. The script - -- The error from apache log - [Tue Mar 21 15:36:05 2006] [notice] child pid 19337 exit signal Segmentation fault

Re: [PHP-DB] php crashes with msyql

2006-03-21 Thread Noah Silverman
Chris, Thanks in advance for all the help. i appreciate it. The script - -- The error from apache log - [Tue Mar 21 15:36:05 2006] [notice] child pid 19337 exit signal Segmentation fault (11)

Re: [PHP-DB] php crashes with msyql

2006-03-21 Thread Chris
Noah Silverman wrote: Chris, Same problem Called from the command line it works. Called through a browser, it crashes. php test.php - WORKS http://server.com/test.php - CRASHES What exactly is in test.php (change database details, but we need to see the test.php script) ? Is it segfau

Re: [PHP-DB] php crashes with msyql

2006-03-21 Thread Chris
Noah Silverman wrote: Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. Thanks, -N -- The issue: when I load a php file in a browser that references

[PHP-DB] php crashes with msyql

2006-03-21 Thread Noah Silverman
Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. Thanks, -N -- The issue: when I load a php file in a browser that references mysql, it crashes the a

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Giff Hammar
Can you use something like this (I haven't tried it)? $search = '/^0a/'; // Looks at the beginning of the stream for 0a $replace = ""; // Replace with this $limit = 1; // How many you want to do $new_file = preg_replace($search, $replace, $old_file, $limit); Giff -Original Message- Fro

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
I tried purposely corrupting the file by adding blank spaces at the beginning of the echo: echo " ",$data; The 0a was put in at the beginning again, followed by the spaces and then the file. Mickey -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Tuesday, Mar

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
Here's the code I'm using to upload if it helps: "; echo "Continue"; } mysql_close(); } else { ?> -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 2:07 PM To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] help with

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
Stripslashes causes the download to hang. I've also tried with base64_encode on the upload and base64_decode on the download with the same results. -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 2:07 PM To: [EMAIL PROTECTED]; php-db@lists

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Bastien Koert
If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien From: "Mickey Martin" <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] help with file downloads from MySQL Date: Tue, 21 Mar 2006 12:55:56 -0600 Every time I try to download

[PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
Every time I try to download a file from MySQL it cannot be opened. Using HexEdit, I noticed that all of the files are getting 0a added to the beginning of them (happens with all browsers). I can look at the files with MySQL Query Browser and they don't have the 0a. Using php 4.3.11, Solaris 8, Ap

RE: [PHP-DB] Remove newlines from field

2006-03-21 Thread Giff Hammar
-Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 6:17 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Remove newlines from field >At 04:00 PM 3/20/2006, you wrote: > > >I am using a PHP script to pull information from a FoxPro database

RE: [PHP-DB] Remove newlines from field

2006-03-21 Thread Giff Hammar
-Original Message- From: Ludvig Ericson [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 5:54 PM To: Giff Hammar Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Remove newlines from field Mind you Pearl programmers, what would that do? [snip] It changes the end of line delimiter