How we can retrieve the data in the result set of MySQL using PHP?

1. mysql_fetch_row
This function will return a row where the values will come in the order as they are defined in the SQL query, and the keys will span from 0 to one less than the number of columns selected.

2. mysql_fetch_array

This function will actually return an array with both the contents of mysql_fetch_rowand mysql_fetch_assoc merged into one. It will both have numeric and string keys which will let you access your data in whatever way you’d find easiest.

3. mysql_fetch_object
The mysqli_fetch_object() function returns the current row of a result set, as an object.

4. mysql_fetch_assoc
This function will return a row as an associative array where the column names will be the keys storing corresponding value.