How to Extract Data from a Specific Column into an Array in PHP?

Extracting Column Data into an Array in PHP

When fetching data from a MySQL database using mysql_fetch_array, you can retrieve a single row of results as an array. However, what if you need to extract data from a specific column across all rows, organizing it into an array? Here's how you can achieve this.

One effective approach involves looping through the rows you fetch from the database:

<code class="php">$column = array();

while ($row = mysql_fetch_array($info)) {
    $column[] = $row[$key];
}</code>

In this code:

• $column is the array that will store the column values.
• The while loop iterates through each row returned by mysql_fetch_array.
• For each row, the value of the key column is appended to the $column array.

By implementing this technique, you can conveniently extract data from a specific column into a dedicated array, making it accessible for further processing or analysis.

The above is the detailed content of How to Extract Data from a Specific Column into an Array in PHP?. For more information, please follow other related articles on the PHP Chinese website!