Get row count in Drupal 6 , Get row count in drupal 6

The below function has to be written after the execution of query using db_query();

db_affected_rows()

function will return the number of rows the query return;