On Thu, 21 Aug 2003 17:56:55 -0400
Rajesh Kumar [EMAIL PROTECTED] wrote:
But does anyone know of a way to find out the number of seconds it took
to execute a particular query using PHP?
use microtime(); - http://php.net/microtime
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of rows
in the resultset.
But does anyone know of a way to find out the number of seconds it took
to execute a particular query using PHP?
Why I need this is because, I would like to execute
At 17:56 -0400 8/21/03, Rajesh Kumar wrote:
Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of
rows in the resultset.
But does anyone know of a way to find out the number of seconds it
took to execute a particular query using PHP?
Why I
Why is the standard-receiver of a reply to the list, the original poster, not the list
itself?
- Original Message -
From: Bernhard Döbler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:58 AM
Subject: Re: Simple C API question
Hi Travis,
so far I see, you
via private mail.
Bernhard
- Original Message -=20
From: Andrew [EMAIL PROTECTED]
To: Bernhard D=F6bler [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 10:21 AM
Subject: RE: Simple C API question
because you are the sender! Not the list also not everyone wants to =
see
and the regular C-character-functions.
http://www.mysql.com/doc/en/mysql_fetch_row.html
Regards
Bernhard
- Original Message -
From: Travis McLeskey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 10:04 PM
Subject: Simple C API question
Question: Can I
Maybe this is a stupid question but I couldn't find suitable sample code or
an answer in the manual.
mysql_fetch_row() returns a MYSQL_ROW representation of a row of data.
According to the manual, this is an array of counted byte strings.
mysql_fetch_field() returns a MYSQL_FIELD with members
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
if (mysql_list_fields( mysql, some table name, some field name))
mysql_store_result and
At 10:57 -0600 2/19/03, William R. Mattil wrote:
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
if (mysql_list_fields( mysql, some table
At 11:13 -0600 2/19/03, Paul DuBois wrote:
At 10:57 -0600 2/19/03, William R. Mattil wrote:
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
Thanks, it's exactly what I'm looking for, suppose I've a lot of work,
becouse (for any interested) it's anexcellent option instead ADO and MyODB
but . the only matter it's a big time to establish a connection, after
that, everything is right.
Somebody know's other option ?
sql,db
Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API can
be used from VB 6.0 ?
What I'm looking for is to access MySQL DB from an application maded in
Visual Basic 6.0 SP5 without using MyODBC, is there some way to do it ?
I'll appreciate any directions that you can give me or
There has been some work done on this by the folks at
http://www.icarz.com/mysql/They have a dll that can be used to replace ADO for mysql.
Haven't
personally used it, but they say its faster.-Nick
Efren Pedroza said:
Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API
can
!!!
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 8:33 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: API++ Question
There has been some work done on this by the folks at
http://www.icarz.com/mysql/They have a dll that can be used
In the MYSQL struct in the C API, how does one access the MYSQL_FIELD data?
for example, and MYSQL struct has
MYSQL_FIELD *fields;
as a member variable. However, when I try to access any of the variables within fields
for example, mysql.fields[0].name, I get a segmentation fault.
Does anyone
In a table, I declared a column which is an integer unsigned.
After calling mysql_fetch_row, I need to convert the value of the column
(i.e. row[0]) to a string.
I tried to solve it doing this:
char var[11];
sprintf (var, %u, row[0]);
, but it doesn't work.
Is *row[0] an unsigned int?
Can
At 5:09 + 3/28/02, Federico Halperin wrote:
In a table, I declared a column which is an integer unsigned.
After calling mysql_fetch_row, I need to convert the value of the
column (i.e. row[0]) to a string.
According to the manual, *all* column values are returned as strings.
I'd say you
]]
Sent: Thursday, March 28, 2002 10:40 AM
Subject: C API question
In a table, I declared a column which is an integer unsigned.
After calling mysql_fetch_row, I need to convert the value of the column
(i.e. row[0]) to a string.
I tried to solve it doing this:
char var[11];
sprintf (var, %u, row[0
hi,
I think u don't need to convert it in to string...
all the column values comes out in string only...
I have used it...
Chetan Lavti
-Original Message-
From: Federico Halperin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 10:40 AM
Subject: C API question
In a table, I
Hi,
I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
SET @var, etc.).
I want to execute all these instructions from a C program , using the API.
It is possible to use the function mysql_query(), to execute all the
instructions contained in the file in a single call
Message-
From: Javier [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 5:35 AM
To: [EMAIL PROTECTED]
Subject: C API Question
Hi,
I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
SET @var, etc.).
I want to execute all these instructions from a C program
At 11:35 + 3/20/02, Javier wrote:
Hi,
I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
SET @var, etc.).
I want to execute all these instructions from a C program , using the API.
It is possible to use the function mysql_query(), to execute all the
instructions
Hi, all MySQL team
Thanks for your former help. Here is another question:
As MySQL support multiple instances, each instance will
run with different socket file and tcp/unix port number.
I want to know when using MySQL client programs like
mysqladmin to connect different instances, are both
Hi,
I have this statement:
res = mysql_query(my_connection, "SELECT * FROM student WHERE studnum =
31665222");
How do I change this so that I can use a variable instead of an explicitly
coded studnum?
Regards,
Evan
Evan James Dembskey wrote:
Hi,
I have this statement:
res = mysql_query(my_connection, "SELECT * FROM student WHERE studnum =
31665222");
for example something like this:
char query[96]="SELECT * FROM student WHERE studnum=";
int studnum;
studnum=get_studnum();
Hi,
If this is not the appropriate list for this question, please accept my
apolgies and kindly direct me to the correct list.
I have attempted to install MySQL under CLOS 1.2 (Corel Linux), using the
instructions found in Howard Schultens' "MySQL for dummies - part 1". I have
worked through
26 matches
Mail list logo
