[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msqlperl
Subject:    RE:
From:       david Wozmak <wozmak () tiac ! net>
Date:       1998-04-09 18:04:15
[Download RAW message or body]

Hi Ramesh!

your problem is fairly simple to solve.

When you access a table, you not only get the data you asked for, you also get some \
information ABOUT the data ("Metadata").

This bit of psuedo code shows you the drill:

use Msql;

$db_server = Msql->Connect;
SelectDB $db_server 'yourDatabaseName';
if ($db_server) {

	$indexCall = Query $db_server "SELECT indexField FROM tableName";
	numberOfEntries = $indexCall->numrows;
}


David Wozmak
atelierDwoz, Inc.
70 Franklin St.
Milford, NH 03055

603-673-3254 vox
603-673-5003 fax

http://www.empire.net/~wozmak/

-----Original Message-----
From:	Ramesh C. Pandey [SMTP:ramesh@netfx.net]
Sent:	Thursday, April 09, 1998 3:19 AM
To:	owner-msqlperl@franz.ww.tu-berlin.de; msqlperl@franz.ww.tu-berlin.de
Subject:	

Hi,
	I am using mSQL ver 2.03, and msqlperl 1.17,
Please tell me the way i can find the toatl no of record in a table without
maing any changes in the table or its structure.

Thanks for your any help

Ramesh

-------------------------------------------
Combit Advertising Network Limited
e-143 greater kailash part 2
new delhi - india
tel : 91-11-6446815, 16
fax : 91-11-6467322
url : http://www.netfx.net
-------------------------------------------
From : Combit Programming Team
----------------------------------------------------------------------
To unsubscribe from this list send a message containing "unsubscribe"
to msqlperl-request@franz.ww.tu-berlin.de

----------------------------------------------------------------------
To unsubscribe from this list send a message containing "unsubscribe"
to msqlperl-request@franz.ww.tu-berlin.de


[prev in list] [next in list] [prev in thread] [next in thread]