[PHP-DB] Re: Images and PHP

2003-08-21 Thread Nadim Attari
PHP http://www.php.net/manual/en/ref.image.php ImageMagick http://www.imagemagick.org/www/identify.html PEAR: Imagick http://pear.php.net/package-info.php?package=imagick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SELECT FROM 2 or more tables

2003-08-21 Thread Brent Baisley
You rarely want to do a join with no filters is what i was trying to get at. On Wednesday, August 20, 2003, at 04:20 PM, Ben Lake wrote: Rarely want to do joins? That's a new one. Ben -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003

[PHP-DB] select and comparison of fields,

2003-08-21 Thread Dave [Hawk-Systems]
looking for a better way to query and cehck for overlapping timeframes. am selecting records for display that has 3 fields of importance; date_time (unix timestamp) session_time (in seconds) user_id (text field) Of all the sessions recorded, we are looking for a

[PHP-DB] DISTINCT not working

2003-08-21 Thread Dillon, John
Any ideas on why the DISTINCT would not work in the following testing code: $query=CREATE TABLE IF NOT EXISTS temp3TEMP SELECT DISTINCTROW ROUND($tbl2.Net*.175,2) AS ExpNet175, CONCAT($tbl2.Journal,$tbl2.Description) AS CON175 FROM $tbl2 WHERE

[PHP-DB] RE: DISTINCT not working

2003-08-21 Thread Dillon, John
Please ignore this question - sorry, it does actually work. However, I still have no suggestions on whether I should try to uninstall Apache 2.0.47 and install the 1.x version to be compatible with PHP. ***previous query*** ... while setting PHP/MySQL/Apache up on my computer to try solve this

[PHP-DB] Segmentation fault caused by PHP ODBC

2003-08-21 Thread Tommy Apel
Hi I'm having a little problem ondestanding whats going on The problem is that some and only some of my odbc_exec()'s functions while others don't and cause an segmentation fault in apache1/2 My configuration is SuSE 8.1 with Apache2.0.44, PHP4.3.1 --with-iODBC after that i've added FreeTDS

[PHP-DB] Segmentation fault caused by PHP ODBC

2003-08-21 Thread Tommy Apel
Hi I'm having a little problem ondestanding whats going on The problem is that some and only some of my odbc_exec()'s functions while others don't and cause an segmentation fault in apache1/2 My configuration is SuSE 8.1 with Apache2.0.44, PHP4.3.1 --with-iODBC after that i've added FreeTDS

[PHP-DB] cancel of 20030821160143.36029.qmail@pb1.pair.com

2003-08-21 Thread Tommy Apel
cancel by original author -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Need For SPEED

2003-08-21 Thread Ignatius Reilly
Sorry I don't seem to get it. 1. What isthe import function provided in PHPList ? 2. What do you mean by initialize each data record ? Ignatius _ - Original Message - From: Creigh Shank [EMAIL PROTECTED] To: Ignatius Reilly [EMAIL PROTECTED] Sent: Thursday,

[PHP-DB] Segmentation fault (11) with PHP ODBC

2003-08-21 Thread Tommy Apel
Hi I'm having a little problem ondestanding whats going on The problem is that some and only some of my odbc_exec()'s functions while others don't and cause an segmentation fault in apache1/2 My configuration is SuSE 8.1 with Apache2.0.44, PHP4.3.1 --with-iODBC after that i've added FreeTDS

[PHP-DB] Error updating db when using a '

2003-08-21 Thread Aleks @ USA.net
I have a strange problem I am adding records into a MySQL db... there is a description column and everything works fine when I add a new record. When I try to edit an existing record it fails if I us an apostrophe ['] in the field. I thought that addslashes would take care of this but it is

RE: [PHP-DB] Error updating db when using a '

2003-08-21 Thread Hutchins, Richard
The only thing I see in your code that looks a bit odd are the parens around your sql statement. I'm not saying that they're causing the problem, just that I've not seen them used in that manner before. May I suggest that you echo out the $sql statement to the browser? Then copy and paste all of

RE: [PHP-DB] Error updating db when using a '

2003-08-21 Thread Aleks @ USA.net
Found the problem.. seems that spanning the sql statement with a carriage return messed something up. It works fine now.. Sorry about the return receipt earlier... won't happen again.. Thanks Aleks -Original Message- From: Aleks @ USA.net [mailto:[EMAIL PROTECTED] Sent: Thursday,

[PHP-DB] Browser timing out.

2003-08-21 Thread J. Michael Roberts
Okay, I'm going mildly crazy now. I've got a huge query that runs and does all sorts of things...but the problem is that it's taking longer than the proxy server will allow to generate the HTML, thus the browser (IE) reports a timeout. I've successfully executed the entire script using Netscape,

Re: [PHP-DB] Browser timing out.

2003-08-21 Thread colbey
Perhaps change it to an offline report? I've done that in the past, it get's scheduled or backgrounded and the results are either emailed to the person, or generated report stored in the database for quick load later on (user gets email that report is ready for viewing).. On Thu, 21 Aug 2003,

Re: [PHP-DB] Browser timing out.

2003-08-21 Thread J. Michael Roberts
unfortunately, it's not something that can be offline. What's actually happening is the database is being queried for information that allows the PHP script to find data files to be sent to the printer. The query really isn't the problem, it's the sending of data when there is ALOT of data being

Re: [PHP-DB] Browser timing out.

2003-08-21 Thread colbey
Look at using server side compression, mod_Gzip or similar, PHP4.something also has compression handler built in.. When dealing with compressing raw HTML pages, very high compression levels can be reached.. Snippit from my mod_gzip+apache+php logs: ip.ip.ip.ip - - [21/Aug/2003:17:17:01 -0400]

Re: [PHP-DB] Browser timing out.

2003-08-21 Thread J. Michael Roberts
I've been going with the invisible data mathod right now and it doesn't seem too bad. What happens on the page is not much to look at and it only returns maybe 1K while the script is running. However, what's happening in the background is a huge-ass transfer of data. To the user, all that's

[PHP-DB] Re: Transferring MySQL data.

2003-08-21 Thread Roberto Dragva Filho
You can use phpmyadmin. see http://www.phpmyadmin.net/ roberto Hugh Dickinson [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] This is probably a stupid question, but I'm pretty new at this! Having built test MySQL databases for my website on my home machine, is it possible to

[PHP-DB] Need For SPEED

2003-08-21 Thread Creigh Shank
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create an e-mailing list for our 5.6 million book club members. Unfortunately, the import speed for importing records (at record number 150,000 the rate is about 2,000 records per hour). We're running on the following: P4

Re: [PHP-DB] Need For SPEED

2003-08-21 Thread Phil Driscoll
I'm not familiar with PHPList but... You might be able to get a significant speed increase by creating indexes in MySQL on some more of the fields in the table. For example, if the list code checks for duplicate email addresses, and the email address field is not indexed, then creating an

Re: [PHP-DB] Need For SPEED

2003-08-21 Thread Ignatius Reilly
What is your data load method? What is the type of your table(s)? With LOAD DATA and text files, I load several million rows in about a minute. Also please don't cross-post. Better first find out what the most suitable mailing list is. Ignatius _ - Original Message

Re: [PHP-DB] Need For SPEED

2003-08-21 Thread John Stoffel
Creigh == Creigh Shank [EMAIL PROTECTED] writes: Creigh Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, Creigh PHPList, to create an e-mailing list for our 5.6 million book Creigh club members. Unfortunately, the import speed for importing Creigh records (at record number 150,000 the