get the count of table rows

I think that’s you must using :

$wpdb->get_results( “SELECT * FROM {$wpdb->prefix}options WHERE
option_id = 1”, OBJECT );

And if you give us the message of error ?