join problem..?

[eluser]sl3dg3hamm3r[/eluser]
[quote author="amira_fcis" date="1258553511"]coz i did my best but i couldn't reach my target result[/quote]

And what did you do until now?

Code:

$tmpName = "";
foreach ($query->result() as $row)
{
  if ($tmpName != $row->Name) {
    echo $row->Name . " " . $row->Value;
    $tmpName = $row->Name;
  } else
    echo $row->Value;
}

This is some untested code. It implies that you have 'Name' and 'Value' in your result-set.