how can retrieve data in a result set of mysql using php

1. Using mysql_fetch_row function. This will return an indexed array.
2. Using mysql_fetch_array function. Fetch a result row as an associative array, a numeric array, or both.
3. Using mysql_fetch_object function. This will return the result set as an object.
4. Using mysql_fetch_assoc function. This will Fetch a result row as an associative array