[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

what function is used to know the no. of rows returned from the database in case of an odbc connection?

mysql_num_rows() is the function used to know the no. of rows returned from the database.

when we use odbc connection, what function we need to use to know  the no. of rows returned from the database .i am using mdb as database.
0
designersx
Asked:
designersx
  • 3
  • 2
1 Solution
 
therealmongooseCommented:
dim lngRecords as long
rst.movelast 'must move to last record to get full record count
lngRecords = rst.recordcount
0
 
designersxAuthor Commented:

sir i am using the php language, so i don't think this syntax would work in php.
0
 
Chris HarteThaumaturgeCommented:
You have answered your own question. mysql_num_rows returns the number of rows in a result.

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
echo $num_rows." Rows\n";



0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
designersxAuthor Commented:
>>You have answered your own question, haha
<<no, sir

i am not using mysql as database. i am using mdb as database and in that mysql_num_rows will not be used . i am using an odbc connection to deal with mdb database.
0
 
Chris HarteThaumaturgeCommented:
My bad. All the odbc functions are listed here

http://uk3.php.net/manual/en/ref.uodbc.php

The one you want is
odbc_num_rows()
0
 
designersxAuthor Commented:
good
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now