[RESOLVED] change how the array data is displayed

[Tank_Girl]

This is so specific I couldn't even search for an answer.
I've tried other methods but this is the only one that come close.

I need to list the Alts of a Roster and have it into a single string.
This code is almost what I need, as it will echo a list.

$rostersql=" SELECT name
        FROM roster_members
        WHERE LOWER(officer_note)='ALT-" . strtolower($name) . "'";
$result2=mysql_query($rostersql);
        if (mysql_numrows($result2) > 0)
        {


while($row = mysql_fetch_array( $result2 )) {
	// Print out the contents of each row

echo $row['name'];
    echo "<BR>";


} 

}else{
echo "No Alts";
}

But I need to get the output to be "$alt = name1 name2 name3" and so on so it can be called again later to be put into a table.
Basically the whole list together with a space between each name.

[Piranha]

I don't know if I understand this correctly, but something like this should do the trick.

$rostersql=" SELECT name
        FROM roster_members
        WHERE LOWER(officer_note)='ALT-" . strtolower($name) . "'";
$result2=mysql_query($rostersql);
        if (mysql_numrows($result2) > 0)
        {

$alt = ""; // added row
while($row = mysql_fetch_array( $result2 )) {
	// Print out the contents of each row

echo $row['name'];
    echo "<BR>";
    $alt .= $row['name'] . " "; // added row

} 

}else{
echo "No Alts";
}

In the future please use [ php] and [/code] instead of [ code] to display the code. It will colormark everything and make it easier to find possible errors.

[jmack159]

why not use implode?

$rostersql=" SELECT name
        FROM roster_members
        WHERE LOWER(officer_note)='ALT-" . strtolower($name) . "'";
$result2=mysql_query($rostersql);

if(mysql_numrows($result2) > 0){

$row = mysql_fetch_array($result2);
// Print out the contents of each row

$alt = implode(" ", $row);
echo $alt;

}else{
   echo "No Alts";
} 

[jlt]

Does this do the trick?

$alt = $row[0] . " " . $row[1] . " " . $row[2] ;

[laserlight]

That will not work, jmack159, since the names are apparently in a column in the database table, not all on one row.

[Tank_Girl]

I went with suggestion one, took out the "echos" and called the $alt later and it worked perfectly thank you Piranha

jlt I tried that one before I posted, and it was NOT happy.. lol

[Tank_Girl]

oh BTW thanks for letting me know about the php versus code in the BB.
I wouldn't have known otherwise. I'll make sure I use that next time I post.