Hello all,
I have a cronjob that runs a PHP script against MySQL. The script takes 5
minutes to process 4000 records (approximately 12 records per second). Here
are the top two entries from top:
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
8671 mysql 25 0 2017
_ID =\"$company_ID\"");
echo "$state - $city - $name - $state_count\n";
}
}
I would like to incorportate each of the queries that uses the count(*)
function into the associated query outside the while() lo
Using phpMyAdmin, you can grant a user specific privileges to do just what
you are asking about. If you only want the data changed, give them some or
all of these: SELECT, INSERT, UPDATE, and DELETE. You can specify how much
the user can see or change at the level of the database, table, or colum
You may be able to view this report in Excel and print it from there.
If this is an option, do the following in Excel:
1. Data -> Import External Data -> New Web Query
2. Enter the URL for your report in the Address field and click Go. It
is possible to start at one URL and browse to the report i
One other trick is to echo out your query before actually
running it so that you don't update all of your records by mistake.
Ryan Marks
-Original Message-
From: Hull, Douglas D [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 10:40 AM
To: Note To php mysql List (E-mail)
S
Henrik,
It's possible that the database is interpreting your date as a couple of
subtraction operations. I always use quotes or single ticks around my
dates when refrencing them in SQL.
Example:
INSERT into some_table (date) values ("2003-07-25");
Give a sample of your code so that your proble
urn $retval;
}
?>
OUTPUT:
19 year(s), 229 day(s) 05:22:01
Hope this helps,
Ryan Marks
-Original Message-
From: John Ryan [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 02, 2003 2:31 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] subtracting dates...
Hi,
In mySQL,
Not necessarily. You can wget /path/to/file.php or my personal preference
is not to use wget, but php directly
/path/to/php/executable /path/to/file.php
Just a thought,
Ryan
-Original Message-
From: Jonathan Villa [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 3:28 PM
To: [EM
My bad... wget does require http or ftp protocol and a hostname that can be
resolved by the server.
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 3:47 PM
To: Ryan Marks; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB
This is some code I already use... you may wish to change the way you
retrieve you whois data.
Ryan
Whois
Hostname:
$host";
//backwards tick marks will run this command on the server and echo's it
out to the screen
echo `whois $host`;
echo "";
//get the tim
I Googled for your warning message and found this:
http://www.phpbuilder.com/mail/php-windows/2000111/0024.php
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 5:52 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] No tuples available
Is th
11 matches
Mail list logo