Community Documentation

db_num_rows

5 database.mysqli.inc db_num_rows($result)
5 database.pgsql.inc db_num_rows($result)
5 database.mysql.inc db_num_rows($result)

Determine how many result rows were found by the preceding query.

Parameters

$result: A database query result resource, as returned from db_query().

Return value

The number of result rows.

Related topics

▾ 32 functions call db_num_rows()

aggregator_parse_feed in modules/aggregator/aggregator.module
block_admin_configure_validate in modules/block/block.module
block_box_form_validate in modules/block/block.module
blog_block in modules/blog/blog.module
Implementation of hook_block().
book_block in modules/book/book.module
Implementation of hook_block().
book_export in modules/book/book.module
Menu callback; Generates various representation of a book page with all descendants and prints the requested representation to output.
book_menu in modules/book/book.module
Implementation of hook_menu().
comment_render in modules/comment/comment.module
Renders comment(s).
db_table_exists in includes/database.mysqli.inc
Check if a table exists.
db_table_exists in includes/database.pgsql.inc
Check if a table exists.
db_table_exists in includes/database.mysql.inc
Check if a table exists.
drupal_client_ping in modules/drupal/drupal.module
Callback function from drupal_xmlrpc() called when another site pings this one.
filter_list_format in modules/filter/filter.module
Retrieve a list of filters for a certain format.
flood_is_allowed in includes/common.inc
Check if the current visitor (hostname/IP) is allowed to proceed with the specified event. The user is allowed to proceed if he did not trigger the specified event more than $threshold times per hour.
forum_block in modules/forum/forum.module
Implementation of hook_block().
locale_add_language_form_validate in includes/locale.inc
Validate the language addition form.
node_page_default in modules/node/node.module
Menu callback; Generate a listing of promoted nodes.
node_type_delete_confirm in modules/node/content_types.inc
Menu callback; delete a single content type.
node_type_save in modules/node/node.module
Saves a node type to the database.
path_nodeapi in modules/path/path.module
Implementation of hook_nodeapi().
ping_cron in modules/ping/ping.module
Implementation of hook_cron().
statistics_block in modules/statistics/statistics.module
Implementation of hook_block().
system_admin_theme_submit in modules/system/system.module
system_initialize_theme_blocks in modules/system/system.module
Assign an initial, default set of blocks for a theme.
system_update_159 in modules/system/system.install
Retrieve data out of the old_revisions table and put into new revision system.
system_update_179 in modules/system/system.install
Update base paths for relative URLs in custom blocks, profiles and various variables.
taxonomy_render_nodes in modules/taxonomy/taxonomy.module
Accepts the result of a pager_query() call, such as that performed by taxonomy_select_nodes(), and formats each node along with a pager.
user_block in modules/user/user.module
Implementation of hook_block().
user_fields in modules/user/user.module
user_get_authmaps in modules/user/user.module
Accepts an user object, $account, or a DA name and returns an associative array of modules and DA names. Called at external login.
user_load in modules/user/user.module
Fetch a user object.
_user_edit_validate in modules/user/user.module

File

includes/database.pgsql.inc, line 188
Database interface code for PostgreSQL database servers.

Code

<?php
function db_num_rows($result) {
  if ($result) {
    return pg_num_rows($result);
  }
}
?>

Comments

Display counts of fields and totals of field values

I'm fairly new to Drupal and haven't a clue how to have a view display counts of various fields in a view.
Using Drupal 2.60, mysql.
I have to print out separate views to show total participants, total number of records, totals for payments and list methods of payment with totals for each payment method.
Are there any step by step information or tutorials please to show how to use code like the above.

Thanks
Roger

Display counts of fields and totals of field values

I'm fairly new to Drupal and haven't a clue how to have a view display counts of various fields in a view.
Using Drupal 2.60, mysql.
I have to print out separate views to show total participants, total number of records, totals for payments and list methods of payment with totals for each payment method.
Are there any step by step information or tutorials please to show how to use code like the above.

Thanks
Roger

Login or register to post comments