Problem with Join function! help!

Anon

$result = mysql_query ("SELECT id, name, link, item FROM panel_items WHERE extra = 'right'");
While (list($id, $name, $link, $item) = Mysql_fetch_row($result)){
$tp_content->set("header_right", "$name");
$tablename = "$item" . "_items";
$query_string = "SELECT header FROM $tablename";
$result_id = Mysql_Query($query_string) or die ("Display_db_query : " .Mysql_Error() . "");
$res = "";
while ($row = mysql_fetch_row($result_id))
$res .= join(" ", $row);
$tp_content->set("content_right", $res);
$tp_content->parse("table-right");
$num++;
$res = "";
}
$tp_content->parse();
$tp_content->spit();

The result of this piece of code is :

test item 1test item 2test item 3

But thats wrong...it has to have breakz like :

test item 1
test item 2
test item 3

I tried to put it all in an array and store it like :

$array[1] = test item 1
$array[2] = test item 2
$array[3] = test item 3

Anyone know how i can do this ?
-Galo

matto

at a glance, I think here's the problem:

while ($row = mysql_fetch_row($result_id))
$res .= join(" ", $row);

here you try to join rows that contain only one element. join tries to place the br between two elements of an array - while the row array consists of only one; that's why no brs are inserted.

I would first append all rows to a container array, and then, finally, join them all together, e.g.

$elements = array();
while ($row = mysql_fetch_row($result_id))
array_push($elements, $row);

$res = join(" ", $elements);

Anon

Thanks.....it works but when im parsing the array

$tp_content->set("content_right", $res);

he returns "array" if i say :
$tp_content->set("content_right", $res[1]);
he only returns the first letter!

what am i doing wrong?

matto

the first letter is returned if you address a string as an array ...

hm, I think that somewhere in the code, an array is addressed as a string and the php default output "Array" is stored in $res.

is the "first letter" an r? would be element number 1 of "Array".