Re: [PHP-DB] problem with num_rows (OCIRowCount)

2001-03-19 Thread Joe Brown
I believe OICrowcount() only returns the number of affected DML affected rows, ones affected by insert or update. Use two seperate queries, one for the count, then another for the data. "SELECT COUNT(*) FROM yourTable WHERE yourWhereClause" Or read all the records into an array and count 'em as

[PHP-DB] problem with num_rows (OCIRowCount)

2001-03-19 Thread Mark
Using phplib db_oci8.inc This function ( a method of Db_Sql class) is giving me problems. I've read in one place that it cannot be used for SELECT statements but in another place that it can. function num_rows() { return OCIrowcount($this->Parse); } Then in my code that uses it