PARSING array problem

[harris97]

Hi guys.... i need ur help... please
I have to parse data like this :
55||null|Group1@john~robert~jack#Group2@sisca~sarah~wynona

For now i make function like this :

function listGroups($userID) {
$db = mysql_connect("localhost", "user", "pass");
mysql_select_db("dbtest", $db);
$sqlstring = "select DATA from CONTACTLIST where CUST_ID = '$userID'";
$result = mysql_query($sqlstring) or die (mysql_error());
$row=mysql_fetch_row($result);
$data=$row[0];

$parseGroup = explode("#",$data);
$countUser=count($parseGroup);
for ($i=0; $i<$countUser; $i++)
{
$repl=strpos($parseGroup[$i],"@");
$tempGroupName = explode("@",$parseGroup[$i]);
$groupNameParse = $tempGroupName[0];
if (strpos($groupNameParse,"||") !== false)
{
$remGroup = str_replace("||","|",$groupNameParse);
$explGroup = explode("|",$remGroup);
$groupName = $explGroup[2];
} else {
$groupName = $groupNameParse;
}
$parseList = substr($parseGroup[$i],$repl+1);
$Val[$i][1] = $groupName;
$Val[$i][0] = $parseList;
}
return $Val;
}

$go=listGroups(michael);
$countList=count($go);
for ($i=0; $i<$countList; $i++) {
echo $go[$i][1]."<br>".$go[$i][1];
}

But this function only return value like this :
Group1
john~robert~jack
Group2
sisca~sarah~wynona

my question is how to display data like this:
Group1
John
robert
jack
Group2
sisca
sarah
wynona

Any help would be appreciated thanks

[preetha]

hi,

I think this might help u.

<?php
function listGroups($userID) {
$db=mysql_connect("localhost","user","pwd");
mysql_select_db("test", $db);
$sqlstring = "select name from name where no = '$userID'";
$result = mysql_query($sqlstring) or die (mysql_error());
$row=mysql_fetch_row($result);
$data=$row[0];

$data=str_replace("#"," ",$data);
$data=str_replace("@"," ",$data);
$data=str_replace("||"," ",$data);
$data=str_replace("|"," ",$data);
$data=str_replace("~"," ",$data);
$data=explode(" ",$data);

return $data;

}

$data=listGroups('10');
$countList=count($data);
for ($i=2; $i<$countList; $i++)
{
echo "$i:".$data[$i]."<br>";
}
?>

with regards,
preeth