mysql_fetch_array
will give me an array of a fetched row. What's the best way generate an array from the values of all rows in one column?
you could loop through the array, and create a new one, like so:
$column = array();
while($row = mysql_fetch_array($info)){
$column[] = $row[$key];
//Edited - added semicolon at the End of line.1st and 4th(prev) line
}
There is no function to do this using the mysql extension, you can do this:
$result = array();
while ($row = mysql_fetch_array($r, MYSQL_NUM)) {
$result[] = $row[0];
}
It is apparently marginally faster to fetch the columns in a numerically indexed array, and there is no real benefit here to having the associative array format.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With