Arrays and related trouble!

Rodders

I'm no array-guru, and need some guidance !

I have a DB table from which I am going to fetch a load of data. I need 6 fields from each row (OLD_ID_1, OLD_ID_ID2, OLD_ID_ID3, NEW_ID_1, NEW_ID_ID2, NEW_ID_ID3). There can be anywhere from 1 to 40 rows in the table, so that's between 6 and 240 fields.

For each of those fields, I need to call the same function, with the field value being passed into the function. I believe I can do this with array_walk().

array_walk($my_array, 'my_function');

What I need to be able to do, is get the MySQL results into a single array. However, I'm beaten on this.

I'm not expecting a full set of instructions, just some pointers towards the ideal functions.

Regards

Rodders

codeDV

You just need to apply the array_walk function when you get each row.

N.b: don't use the mysql_fetch_array() function as it duplicates all the fields.

while ($row = mysql_fetch_assoc($result)) {
    array_walk($row, 'my_function');
}

Shrike

$i = 0;
while($data = mysql_fetch_array($myrecordset)){
  $myarray[$i] = $data;
  $i++;
}
foreach($myarray as $key => $arr){
  $myarray[$key] = doSomething($arr);
}

Something like that?

edit: ah yes didn't see the array_walk() part 🙂

Rodders

......that'll work just fine, however there will be duplicate values returned from the database. That's not a huge problem, but I thought I could use array_unique() to get rid of all the duplicates and then use array_walk().

Should have said that initially........

I suppose what I'm after is a function that lets me add an array to an array. I'm sure array_push() can be used, but I can't get my head around the syntax required.

codeDV

Originally posted by Rodders
......that'll work just fine, however there will be duplicate values returned from the database. That's not a huge problem, but I thought I could use array_unique() to get rid of all the duplicates and then use array_walk().

Should have said that initially........

I suppose what I'm after is a function that lets me add an array to an array. I'm sure array_push() can be used, but I can't get my head around the syntax required.

Like I said in my previous post. mysql_fetch_array(), returns an associative array and a zero based indexed array. Instead of mysql_fetch_array(), use mysql_fetch_assoc() or mysql_fetch_row().