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
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 if
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)
Subject: [PHP-DB
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 problem
;
}
$ss=$r ;
if ($ss=9) $ss=0.$ss; //adds a leading 0 if less than 10
$retval=$yy year(s), $dd day(s) $hh:$mm:$ss;
return $retval;
}
?
OUTPUT:
19 year(s), 229 day(s) 05:22:01
Hope this helps,
Ryan Marks
-Original Message-
From: John Ryan [mailto
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:
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
html
headtitleWhois/title/head
body
form name=theform action=whois.php method=post
Hostname: input type=text name=host length=30 input type=submit
/form
?php
//if a domain name was provided
if
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
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
the while() loop. Can this be
done? I assume that the fewer times I need to query the database, the
faster my script will run. Is this true as well?
TIA,
Ryan Marks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
11 matches
Mail list logo