Number of records returned

[Alejandro D. Burne]

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)

selectfield1 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í

Re: Number of records returned

[Cory Hicks]

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]