Skip to content
PHP Logo

In PHP development, what are the implications of using MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH as the second argument in mysql_fetch_array()?

When using mysql_fetch_array() in PHP development, the second argument can be MYSQL_ASSOC, MYSQL_NUM, or MYSQL_BOTH. MYSQL_ASSOC returns an associative array with column names as keys, MYSQL_NUM returns a numerical array with column indexes as keys, and MYSQL_BOTH returns both types of arrays. The choice of which to use depends on how you want to access the data retrieved from the database.

php 
// Example of using mysql_fetch_array with MYSQL_ASSOC
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    // Access data using column names as keys
    echo $row['column_name'];
}

Related questions