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.