Passing an array argument to a function

Anon

Okay I give up! I searched all over and can find no specific help that actually fixes my problem...

I have an array (returned by a MySQL query) that is in the form of column names and not numerical array index values (e.g. $row["field1"], $row["field2"], $row["field3"]
etc, etc)

But when I pass them to a class method (function) the array is empty when I try to use it's contents. And there is no error message before someone asks...

E.G
function getdata($row)
{
$temp = $row["field1"];
}

I have already checked or tried:

Passing by reference (e.g. $object->method(&$row) in the class file
The array is populated before calling the method (it is!)
Read the manual
Read Prof. PHP Prog. book - good, but it's not specifically covered.
A load of other ideas like:

$object->method($row[]) in both the definition and the function call.

Past experience tells me I've missed something obvious but I keep on looking and get no further so any ideas will save my life!

Thanks in advance

Anon

I just realised something wasn't too clear...

I MUST use the column names as I will not know the index numbers.

e.g. It must be $row["field1"] and not $row[0]

gregh

I'm a newbie myself, but here's an attempt to solve your problem...try this:

$query = "select fieldName1, fieldName2, fieldName3 from tableName";

$result = mysql_query($db, $query);

while($row = mysql_fetch_object ($result)) {
$var1 = $row->fieldName1;
$var2 = $row->fieldName2;
$var3 = $row->fieldName3;
}

The mysql_fetch_object returns your $result as an object, whose member variables can be accessed according to field name.

Of course, being a newbie, I only see how this can work for one row of result data. If anyone can enlighten me as to how to collect multiple rows, that'd be way cool.

Hope this helped a little...

Anon

Thanks for the tip - it didn't actually sort out my problem but it did make me think about it in a different way... and then I found the problem.

As I thought, it was a BOS error (bag of shite!!) - when entering the class method I had missed off that crucial "$this->" on some (but not all) of the variable settings!

I knew it was simple but I just couldn't see it for looking!

Thanks

Anon

I am still working on this problem without using a class section but I can't really figure it out how to send array variables to functions (I am new to classes!)