How about from the php api, or something similar:
mysql_num_rows()
Cory
On Thu, 2004-01-15 at 10:43, Alejandro D. Burne wrote:
I'm testing store procedures, and I want to know the number of
records returned from a query.
There is a function or variable to get it through odbc?
I'll be trying with mysql_num_results() but makes me en error (seems
to be made for c api)
select field1 from table where field2=1;
select mysql_num_results() as num;
---Mensaje original---
De: Eve Atley
Fecha: 01/15/04 13:37:42
Para: General MySQL
Asunto: RE: Installing MySQL on Linux, HELP!
I have had some help on my mysql install woes, and here's the latest.
rpm -qa | grep MySQL - this just hung and never returned anything (see
below)
# service mysqld start
or
# service mysql start - these just returned a new command prompt, so
couldn't tell whether or not they worked. I checked my processes and
never
saw mysqld.
I put in 'whereis mysql', and this returned:
/usr/bin/mysql
/user/lib/mysql
/user/share/mysql
/user/share/man/man1/mysql.1.gz
I was going to output a new list of installed packages to ensure that
mysql
was in there, but rpm -qa | ./installed_packages doesn't seem to work
at the
moment...I can't restart the server right now, so perhaps I could kill
and
restart some process? However, this is from yesterday's output:
postgresql-libs-7.3.4-3.rhl9
postgresql-7.3.4-3.rhl9
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9
postgresql-server-7.3.4-3.rhl9
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
_
IncrediMail - El Email ha evolucionado finalmente - Haga clic aqu
--
Cory Hicks [EMAIL PROTECTED]
TRI International
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]