php-sqlite3

1 sqlite3_num_rows and/or sqlite3_has_more - ID: 1644946

Last Update: Settings changed ( gruessle )

Details:

How do I know how many row came back from the query?
sqlite3_num_rows and/or sqlite3_has_more does seam to work.

Thanks

Submitted:

Dennis Kaplan ( gruessle ) - 2007-01-26 03:38

Priority:

Status:

Deleted

Resolution:

None

Assigned:

Nobody/Anonymous

Category:

None

Group:

None

Visibility:

Public

Date: 2007-01-26 04:44 Sender: gruessle I got a solution for this: function sqlite3_num_rows($dbRes) { $n = 0; while(sqlite3_fetch_array($dbRes) != '') { $n = $n + 1; } return $n; } echo "Number of rows: " . sqlite3_num_rows($dbRes). "<br>";

Field	Old Value	Date	By
status_id	Open	2007-01-26 11:16	gruessle
priority	2	2007-01-26 11:16	gruessle
close_date	-	2007-01-26 11:16	gruessle
priority	8	2007-01-26 04:44	gruessle
priority	5	2007-01-26 03:39	gruessle