Mgiyuk

mysqli_fetch_array always returns 99 I have 103 records in table catalogue , however when I run the following function: catalogue $db_table = '`catalogue`'; $db_table_id_field = 'catalogue.ID'; private function countNumRows($db_table,$db_table_id_field){ $where_condition = $this->whereClause(); // is empty string $this->sql = " SELECT COUNT($db_table_id_field) AS count_r FROM $db_table $where_condition; "; /* SELECT COUNT(catalogue.ID) AS count_r FROM `catalogue` ; - this query returns 103 */ $this->result = mysqli_query($GLOBALS["___mysqli_ston"], $this->sql) or die($this->error = mysqli_error($GLOBALS["___mysqli_ston"])); $row = mysqli_fetch_array($this->result,MYSQLI_BOTH); return $row[0];// returns count of 99 rows!WHY???????????? } I only get 99 records. I also tried mysqli_fetch_array($result, MYSQL...