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]