mysql_num_rows

[bnmbb]

Witam ! Kończąc pisanie gry World Of Villages będę zmieniał zapytania z mysql_query na funkcje QuerySingle i Query.

 

Teraz mam takie pytanie :

- czy można (jeśli tak to jak) wyciągnąć z tego ilość zaznaczonych rekordów ?

 

Funkcje.

(Najpierw QuerySingle potem Query)

Najpierw

 

 

/* --------------------------------------------------------- >>>
 public dynamic QuerySingle(string commandText, params object[] args)
  Member of WebMatrix.Data.Database

 Summary:
 Executes a SQL statement (optionally passing parameters) and returns a single record.

 Parameters:
 commandText: The SQL statement to execute.
 args: (Optional) Parameters to pass to the SQL statement.

 Returns:
 The single database record returned by the SQL statement.

 # For SELECT, SHOW, DESCRIBE, EXPLAIN returns a resource on success, or FALSE on error.
 # to access the returned data.
------------- */
 public function QuerySingle( $commandText, $args = null )
 {
   $arg_list = func_get_args();
   $query = empty($args) ? $commandText : vsprintf($commandText, array_slice($arg_list, 1));

   $result = mysql_query( $query );

   if ( gettype($result)=='boolean' ) return $result;
   $qry_db = false;
   if ( mysql_num_rows($result)>0 ) {
  //$_db = mysql_fetch_row($result);//mysql_fetch_assoc($result);//
  //$qry_db = $_db[0];
  //mysql_fetch_array($result, MYSQL_ASSOC);
  $qry_db = mysql_result($result, 0);
   }

   return $qry_db;
 }
/* --------------------------------------------------------- >>>
 public System.Collections.Generic.IEnumerable<dynamic> Query(string commandText, params object[] parameters)
  Member of WebMatrix.Data.Database

 Summary:
 Queries the database using a SQL statement (optionally passing parameters) and returns the results.

 Parameters:
 commandText: The SQL statement to execute.
 parameters: (Optional) Parameters to pass to the SQL statement.

 Returns:
 The results of the query.

 # For SELECT, SHOW, DESCRIBE, EXPLAIN returns a resource on success, or FALSE on error.
 # return data array for dealing with result tables, to access the returned data.
------------- */
 public function Query( $commandText, $parameters = null  )
 {
   $arg_list = func_get_args();
   $query = empty($parameters) ? $commandText : vsprintf($commandText, array_slice($arg_list, 1));

   $result = mysql_query( $query );

   if ( gettype($result)=='boolean' ) return $result;
 if ( mysql_num_rows($result)>0 ) {
  $qry_db = mysql_fetch_array( $result, MYSQL_ASSOC );
  mysql_free_result($result);
  return $qry_db;
   }
   //return;
 }

 

 

 

Pozdrawiam i liczę na odpowiedź