What is the difference between mysql_fetch_array and fetch_row in PHP and how do they handle query results differently?

The main difference between mysql_fetch_array and fetch_row in PHP is that mysql_fetch_array returns a result row as an associative array, a numeric array, or both, while fetch_row returns a result row as a numeric array. If you need to access the query results by both column name and index, you should use mysql_fetch_array. If you only need to access the results by index, fetch_row is sufficient. 

// Example using mysql_fetch_array
$result = mysql_query("SELECT * FROM table");
while ($row = mysql_fetch_array($result)) {
    echo $row['column_name']; // Access by column name
    echo $row[0]; // Access by index
}

// Example using fetch_row
$result = mysql_query("SELECT * FROM table");
while ($row = mysql_fetch_row($result)) {
    echo $row[0]; // Access by index only
}

Keywords

PHP mysql_fetch_array fetch_row query results difference

Related Questions