query("SELECT * FROM auth_tbl"); /* return number of rows selected */ echo "Rows Fetched: " . $res->num_rows() . "
\n"; /* determine the number of columns in the result set */ echo "Columns per row " . ($n_cols = $res->num_fields()) . "
\n"; for ($i = 0; $i < $n_cols; $i++) { /* fetch column names */ echo "Column Names: " . $res->field_name($i) . "
\n"; } ?>