Set multiple rows to a single $variable

[mrt003003]

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

 

The variable is $alderaanfleetalt  and consists of:

 

$fleetname = "FleetName";
$shipname = "Ship Name";

 

Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

 

$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName']; 

 

At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

 

do{ 
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet)); 

 

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

 

Thank you

 

 

[mikesta707]

You only have 1 row because you overwrite the value of $alderaanfleetalt in every iteration of the loop. You may want to concatenate instead of overwriting

 

$alderaanfleetalt = "";//set it to empty string
do{ 
$alderaanfleetalt .=  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];//concatenate each row onto the whole variable
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet)); 

[AbraCadaver]

Make an array of rows to loop through later:

while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet)) { 
   $alderaanfleetalt[] =  $fleetname." ".$row_Alderaanfleet['FleetName']."<br />".$shipname." ".$row_Alderaanfleet['ShipName'];
}

 

Or concatenate with a newline or break or whatever:

 $alderaanfleetalt = "";
while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet)) { 
   $alderaanfleetalt .=  $fleetname." ".$row_Alderaanfleet['FleetName']."<br />".$shipname." ".$row_Alderaanfleet['ShipName']."<br />\n";
}

[mrt003003]

Brilliant!!!

 

Thank you