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

List:       mysql
Subject:    RE: mysql_num_rows
From:       "Sweeney, Darren L" <darren.l.sweeney () ssmb ! com>
Date:       1999-06-30 15:53:25
[Download RAW message or body]

Example code ...

	$dbh = DBI->connect("DBI:mysql:$dbname", "root");

		my $query = "SELECT * FROM table WHERE (column like 'xxx')";
		my $sth = $dbh->prepare($query);
		my $rc = $sth->execute;
		$trades = $sth->rows;
		$sth->finish;
		$dbh->disconnect;

The $trades string will be the number of rows resulting from the query.

Hope this helps

Darren

> -----Original Message-----
> From:	Roger Smith [SMTP:roger@metalab.unc.edu]
> Sent:	Wednesday, June 30, 1999 11:43 AM
> To:	mysql@lists.mysql.com
> Subject:	mysql_num_rows
> 
> Hey all can anyone give me the syntax for mysql_num_rows, I looked in the
> mysql.net page and am not sure about it, 
> do I have to make a query first and then use mysql_num_rows?
> Thnaks
> 
> Roger R. Smith
> roger@metalab.unc.edu
> MetaLab.  I love it and so can you!
> (919) 962-5646
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread6271@lists.mysql.com
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@lists.mysql.com instead.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread6275@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@lists.mysql.com instead.

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