The functions available in MySQL (Part 2)

      In previous articles have discussed four functions that exist in mSQL and at this time we will discuss the four other functions that exist in MYSQL.

5. mysql_fetch_array

            Used to produce an array where each column will be stored twice on each result array where the first store the index numbers starting from number 0 and the second column store index.

            Example :

            mysql_fetch_array($query);

6.mysql_fetch_rows

            Used to produce an array that contains the column.

            Example :

            mysql_fetch_rows($query);

7. mysql_num_rows

            Used to get the number of rows from a select query is executed.

            Example :

            mysql_num_rows($queryselect);

8. mysql_nums_fields

            Used to get the number of columns from a select query is executed.

            Example :

            mysql_num_fields($queryselect);