odbc_num_rows returns -1 ... why?

Mushonov

Hi All,
I have this code -

	function GetDownloads()
	{
	 	$db = 'd:\\my projects\\laviadlab\\source\\db.mdb';

  	$conn = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . $db, "", "");

	try
	{
		$sql =	'SELECT item_id FROM downloads;';

		$rs = odbc_exec($conn,$sql);

		$downloads = odbc_num_rows($rs);			

		odbc_free_result($rs);
		odbc_close($conn);

		return $downloads;

	}
	catch (Exception $e)
	{
		echo $e->getMessage();
	}
}

but $downloads always return -1...

do u know why?
Avi. 🙁

laserlight

Yes. There's an error. You might want to try using [man]odbc_errormsg/man to find out what it is.

Mushonov

laserlight wrote:
Yes. There's an error. You might want to try using [man]odbc_errormsg/man to find out what it is.

welp,
i used odbc_error (with the connection as parameter and without) and nothing.
returns empty string 🙁

any more advices? :queasy:
Avi.

Mushonov

Hey,
according to the comments on odbc_num_rows (http://il.php.net/manual/en/function.odbc-num-rows.php , there's a bug using this function on MS Access.

from one of the comments,

odbc_num_rows for access does return -1. I use count($resultset);

i guess i'll use "Select count(*)" or another db 😉

Avi.