fwolf / fwlib

	 * @param	string	$cond	Condition, can be where, having etc, raw sql string.

	 * @return	int		-1: error/N >= 0: number of rows

	 */

	public function GetRowCount ($tbl, $cond = '') {

		$rs = $this->PExecute($this->GenSql(array(

			'SELECT' => array('c' => 'count(1)'),

			'FROM'	=> $tbl,

			)) . ' ' . $cond);

		if (false == $rs || 0 != $this->ErrorNo()

				|| 0 == $rs->RowCount())

			// Execute error

			return -1;

		else

			return $rs->fields['c'];

	} // end of func GetRowCount

	/**

     * @param   string $condition Raw sql, can be WHERE, HAVING etc

     * @return  int

     */

    public function getRowCount($table, $condition = '')

    {

        $sqlCfg = [

            'SELECT' => ['c' => 'COUNT(1)'],

            'FROM'   => $table,

        ];

        $rs = $this->executePrepare(

            $this->getSqlGenerator()->get($sqlCfg)

            . ' ' . $condition

        );

        if (false == $rs || 0 != $this->conn->ErrorNo()

            || 0 == $rs->RowCount()

        ) {

            // Execute error, rare happen

            // @codeCoverageIgnoreStart

            return -1;

            // @codeCoverageIgnoreEnd

        } else {

            return $rs->fields['c'];

        }

    }

    /**