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 3:04
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 count
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 $tbl2.Dept='$rcc
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
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 0.6
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 0.6
cancel by original author
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sorry I don't seem to get it.
1. What is"the 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: Thur
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 0.6
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 not
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 t
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, August
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,
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,
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
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] "G
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 happe
Ís there a way to get a file version, just like we get the size and
date
Thanks in advance..
Rodrigo Corrêa
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 tr
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 (1.5
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 index
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 --
> "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
23 matches
Mail list logo