pdo row count

[cloudll]

Hey guys,

 

I was wondering if someone could tell me what I have done wrong here.

$sql = "SELECT * FROM login WHERE online='online' ORDER BY username";
$count = $sql->rowCount();

I dont know much, but shouldn't that work?

 

I get this message.

 

PHP Fatal error:  Call to a member function rowCount() on a non-object in C:\wamp\www\engine\engine\engine-multi.php on line 2767

[fastsol]

You need to actually do the query before you can get a row count from it.  Your code is only setting $sql to a string, but you never actually run any query.  Plus you can't run a query with $sql cause it's NOT a db object, it's a string.  You need to run the query from your pdo object, with whatever var you created that with.