Array prob

[Gav]

Hi,

From the query below i wish to output just one string that i wish to use as a basic description of products - i am going to use this string to pass in a hidden field within a form - I know the query is working as i tested the loop by echoing $row->eachfield and got the desired results - where i am having the problem is just returning one string in $contents. I can only get it to return either the last result found or "Array". Would this be correct below - or any other suggestions on this would be most appreciated

function display_contents($table, $session) {
$count = 0;
$query = "SELECT * FROM $table WHERE session='$session'";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {
$contents['quantity'][$count] = $row->quantity;
$contents['title'][$count] = $row->title;
$contents['code'][$count] = $row->code;
$count++;
}
return $contents;
}

THNKS in advance

[eoghain]

I'd say you are building your array backwards.

Instead of this:
$contents['quantity'][$count] = $row->quantity;
$contents['title'][$count] = $row->title;
$contents['code'][$count] = $row->code;
$count++;

Do this:
$contents[$count]['quantity'] = $row->quantity;
$contents[$count]['title'] = $row->title;
$contents[$count]['code'] = $row->code;
$count++;

This will return you an array that you can traverse with a for loop easily. Also it's more logical to read $contents[row1][value of quantity], as apposed to $contents[value of quantity][for row 1].

As for getting your results, I've alwasy had trouble passing arrays, so I usually call them by referance.

function display_contents($table, $session, &$contents) {
// Code removed
return $count;
}

And when I use that function I do it this way:

$contents = array();
$count = display_contents($table, $session, $contents);

Then I have my array and I know how many values exists in it for my looping.