MySQL Function Reference contd..

int mysql_num_rows ( resource $result )
Retrieves the number of rows from a result set. This command is only valid for statements like SELECT or SHOW that return an actual result set. To retrieve the number of rows affected by a INSERT, UPDATE, REPLACE or DELETE query, use mysql_affected_rows().
$result.
The result resource that is being evaluated.
Return value.
The number of rows in a result set on success, or FALSE on failure.

int mysql_num_fields ( resource $result )
Retrieves the number of fields from a query.
Returns the number of fields in the result set resource on success, or FALSE on failure.