1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
.\" msqlNumRows - Return number of rows in a result table
.\" Copyright (c) 1996 Martin Schulze <joey@office.individual.net>
.\"
.\" This program is free software; you can redistribute it and/or modify
.\" it under the terms of the GNU General Public License as published by
.\" the Free Software Foundation; either version 2 of the License, or
.\" (at your option) any later version.
.\"
.\" This program is distributed in the hope that it will be useful,
.\" but WITHOUT ANY WARRANTY; without even the implied warranty of
.\" MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
.\" GNU General Public License for more details.
.\"
.\" You should have received a copy of the GNU General Public License
.\" along with this program; if not, write to the Free Software
.\" Foundation, Inc.,59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
.\"
.\" This manual page is written especially for Debian GNU/Linux.
.\"
.TH msqlNumRows 3 "4 Aug 1996" "Mini SQL" "mSQL Programmer's Manual"
.SH NAME
msqlNumRows \- Return number of rows in a result table
.SH SYNOPSYS
.nf
.B #include <msql.h>
.sp
.BI "int msqlNumRows(m_result *" result );
.fi
.SH DESCRIPTION
The number of rows returned by a query can be found by calling
.B msqlNumRows()
and passing it the result handle returned by
.BR msqlStoreResult (3).
The number of rows of data sent as a result of the query is returned
as an integer value. If a SELECT query didn't match any data,
.B msqlNumRows()
will indicate that the result table has 0 rows (note: earlier versions
of mSQL returned a NULL result handle if no data was found. This has
been simplified and made more intuitive by returning a result handle
with 0 rows of result data).
.SH "RETURN VALUE"
The number of rows in
.IR result .
.SH "SEE ALSO"
.BR msqlQuery (3),
.BR msqlStoreResult (3),
.BR msqlFetchRow (3),
.BR msqlNumRows (3),
.BR msql (5).
|
