---
title: "In how many ways we can retrieve data in the result set of MYSQL using PHP?"  
description: "In how many ways we can retrieve data in the result set of MYSQL using PHP?"  
author: "Anonymous User"  
published: 2011-06-13  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/1056/in-how-many-ways-we-can-retrieve-data-in-the-result-set-of-mysql-using-php  
category: "php"  
tags: ["php"]  
reading_time: 1 minute  

---

# In how many ways we can retrieve data in the result set of MYSQL using PHP?

**mysql_fetch_array -** Fetch a result row as an associative array, a numeric array, or both\
**mysql_fetch_assoc -** Fetch a result row as an associative array\
**mysql_fetch_object -** Fetch a result row as an object\
**mysql_fetch_row —-** Get a result row as an enumerated array

## Answers

### Answer by Anonymous User

**mysql_fetch_array -** Fetch a result row as an associative array, a numeric array, or both\
**mysql_fetch_assoc -** Fetch a result row as an associative array\
**mysql_fetch_object -** Fetch a result row as an object\
**mysql_fetch_row —-** Get a result row as an enumerated array


---

Original Source: https://www.mindstick.com/interview/1056/in-how-many-ways-we-can-retrieve-data-in-the-result-set-of-mysql-using-php

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.