dynamic array items

[tape enterprise]

normally to get my items from mysql to an array i use this code

while($row=mysqli_fetch_array($result))
{
$array[] = array('id' => $row['id'] ect...)
}

anyway I am using some OOP in my code so now I don't know what the row names from mysql are named to use in the while loop so how do I get the row names and then put them in the while loop array.

[smantscheff]

I assume that with "row names" you mean the column names.
You can get them with the functions mysql_field_name and mysql_field_count:

while ($object = mysql_fetch_object($result) {
  for ($i = 0; $i < mysql_field_count($result); $i++) {
    $field_name = mysql_field_name($result, $i);
    $field = $object->$field_name;
    ...
  }
}

[diafol]

Depends which library you're using. Some have their own custom methods and properties for mysql. You using PDO or something else?

[tape enterprise]

so that would get all my field names and I could then use them? how then could I export that array into my code to use?

[diafol]

You mention mysql but are using code for mysqli. Which is it?

[tape enterprise]

mysqli stands for mysql improved its just a better way to connect to mysql with php that's all

[diafol]

Quite right, Ignore a senile old codger. :) I got it mixed up with something else. ANyway, can you post your code here? Even if you've oop-ified it.

[diafol]

Been racking my brains - Got it at last -SQLite was the darned thing I wthought you were using. Feeling stupid now. Mental block. Anyway, haven't used mysqli before, will have a look at it.