Fast/Easy way to extract a column from multi-dimensional array? [message #176831] |
Fri, 27 January 2012 20:08 |
John Drako
Messages: 5 Registered: December 2011
Karma:
|
Junior Member |
|
|
I'm looking for a way to get all the values from the column of a two
dimensional array.
For example, I have a query on a mysql database that returns 10 rows
from the database, I would like to quickly (read low cpu load) extract
all the IDs from all the rows returned to reuse in another query.
So let's say I use:
$arr = mysqli_fetch_all($result, MYSQLI_ASSOC);
and $arr looks like:
RecordID, name, last name, title
RecordID, name, last name, title
RecordID, name, last name, title
RecordID, name, last name, title
RecordID, name, last name, title
RecordID, name, last name, title
etc...
I need to get all the 'RecordID' from the results to reuse in other
queries.
Is there a built in PHP function (compiled code) to accomplish this?
I've read the definitions of all the functions related to arrays and if
it exists, I didn't find it.
The site is very busy and CPU cycles count. I'm trying to avoid left
joining three gigantic tables.
|
|
|