Hey all,
I'm new to the list and SQLite, although I have
about 7 years with MySQL, and going back to Oracle
and Informix a rock's age with databases.
I have the following code in a PHP 5.2.5 install.
$sql="SELECT * FROM bsp_model WHERE makeID=$makeID
ORDER BY model";
$result = $dbHandle->query($sql);
// if 0 records returned, reload drop down with
empty, single selection.
$norows=$result->numRows();
if ($norows==0)
{
echo 'false';
exit;
}
But when it runs I get the following error:
Call to undefined method PDOStatement::numRows()
All the documentation I see on SQLite shows this
as a valid method.
I know that $result is a valid DB object
containing data because if I simply comment out
the test for zero records everything works fine
(because there is data in the object), but I still
need the test for zero records.
Any suggestions would be greatly appreciated.
Skip
--
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX & DHTML development framework.
http://phpenguin.bigskypenguin.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
