hi to all,
how can I set up a timer that will tell me how long a query takes to run.
for example, if I run the following query, I would like to know how long
it
takes.
[...]
Thanks in advanced
Nato
I don't remember where I 've found this snippet, but it works well.
$TIMER_START =
Whoops :),
Yes, this is using phpMyAdmin, trying to use the Insert data from a
textfile into table function, which uploads a file and the attempts to
LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when
upgraded to PHP 4.2.1, it gave the error :
The file '/tmp/phpr4WYQY'
I am having problems connecting to an Access database. I am using Windows
2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
the Access (.mdb) driver, and have a username and password. What's going
on?? Thanks, Bill
The code I have used is as follows:
Not sure how to over come this, the result of a database query keeps giving
me this:
?php
/* Get Ip address, where they came from, and stamp the time */
if (getenv(HTTP_X_FORWARDED_FOR)){
$ipaddy = getenv(HTTP_X_FORWARDED_FOR);
} else {
$ipaddy = getenv(REMOTE_ADDR); }
$referrer =
The quick answer is that that is what it's supposed to return... that's all
the result is. A nicer, longer answer is to give you some of my code so you
can see one way that you actually get the data out (I use sybase_fetch_row,
but you can also use db_fetch_array which returns an associated
At 11:42 -0600 6/12/02, Jas wrote:
Not sure how to over come this, the result of a database query keeps giving
me this:
?php
/* Get Ip address, where they came from, and stamp the time */
if (getenv(HTTP_X_FORWARDED_FOR)){
$ipaddy = getenv(HTTP_X_FORWARDED_FOR);
} else {
$ipaddy =
I totally didn't even see that section of code. I am sorry I wrote back
like you were an idiot! I think we know who the real idiot is today... :-)
Sorry again!
-Natalie
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 1:53 PM
To: Jas;
Thanks a ton, I was really looking right past that variable.
Jas
Paul Dubois [EMAIL PROTECTED] wrote in message
news:p05111763b92d3addd3b4@[192.168.0.33]...
At 11:42 -0600 6/12/02, Jas wrote:
Not sure how to over come this, the result of a database query keeps
giving
me this:
?php
/* Get
Im sorry if this mensaje is posted twice. I sent it yesterdays, but
then my ISP had problems with e-mail and I lost dozens of them and dont
know if sent OK.
Hi all,
What Im trying to do here is not inside PHP nor MySQL books I have. I
need to query the DB to look the max result in a column.
is
select MAX(column name)
what you are looking for? I know it works on numeric columns, I'm not sure
if it works on non-numbers, you'd have to look it up in a SQL Tutorial
somewhere.
Good luck!
-Natalie
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent:
Thanks Natalie Ed. This Works just fine.
What I want to do, is let a person subscribe new affiliates without
having to look up what the last affiliate's number was and show the next
one in the new affiliate form.
César Aracena
IS / MCSE+I
Neuquén, NQN
(0299) 156-356688
(0299) 446-6621
I've duplicated your problem. I know I've had this working before, I'll let you know
if I can figure it out. :-)
Ryan
-Original Message-
From: Bill Hudspeth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:22 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Connecting to MS
It is the error message you get when you haven't selected the database file for your
DSN. Go to your DSN, click configure, and click the SELECT button on the dsn. :-)
Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, June 12, 2002 1:09 PM
To: [EMAIL PROTECTED]
I finally got this auto-update script to work, thanks for your so many
replies.
Tony S. Wu
Jason Wong at [EMAIL PROTECTED] wrote:
On Saturday 08 June 2002 21:34, Tony wrote:
I do appreciate your reply.
Yes, I've tried to track down the problem.
I comment-out the fopen() function and use
select max(id) as amount from table
César aracena [EMAIL PROTECTED] wrote in message
003301c21240$0cdcf790$89c405c8@gateway">news:003301c21240$0cdcf790$89c405c8@gateway...
I'm sorry if this mensaje is posted twice. I sent it yesterdays, but
then my ISP had problems with e-mail and I lost dozens
hi
when i execute this script i an error
---function
this func is in file functions.php and the func deletecookies();
auuser($login,$passwd)
{
global $db_server,$http_host,$db,$db_user,$db_pass,$doc_root;
Come to think now, you are all right about making the field
auto_increment, instead of asking the DB which one is the following
number. It's just that I have a pretty large old DB in which this field
is NOT in sequence and should be imported before I keep designing the
scripts.
Thanks to all of
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...
Whoops :),
Yes, this is using phpMyAdmin, trying to use the Insert data from a
textfile into table function, which uploads a file and the attempts to
LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when
upgraded to
I had to reinstall PHP SQL, now whenever I run a PHP script I get the
following error, can someone please help.
Thanks
CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:
--
PHP Database Mailing List
Is there a PHP routine anywhere to execute a series of MySQL queries in a
text file?
I know how to do this via the command line or by using PHPMyAdmin, but I
need to do it in my own PHP script, and some of the queries span more than
one line.
--
Bruce Vander Werf
[EMAIL PROTECTED]
--
PHP
Hi César,
As others have obviously pointed out using MAX() is the way to go. Need I
mention that you can also insert values of your own making into an
auto_increment column as long as they are not already used by some other
record.
In your case since you have old records with IDs of their own
On Thursday 13 June 2002 10:48, Bruce Vander Werf wrote:
Is there a PHP routine anywhere to execute a series of MySQL queries in a
text file?
I know how to do this via the command line or by using PHPMyAdmin, but I
need to do it in my own PHP script, and some of the queries span more than
On Thursday 13 June 2002 06:00, suman wrote:
hi
when i execute this script i an error
---func
tion
this func is in file functions.php and the func deletecookies();
auuser($login,$passwd)
{
global
23 matches
Mail list logo