Exporting to Excel Spreadsheet help

[mattv10]

Hi I have data which I'm exporting to excel using PHP & header("Content-Type: application/vnd.ms-excel") etc.....

Here is what I want to do...

I'm looping through the recordset and when there is a duplicate environment name and version name I want to only print the detail information and not the environment name and version again... So it would look something like this...

Environment 1 Details1
-----------------Details2
-----------------Details3 etc...

rather than...

Environment 1 Details1
Environment 1 Details2 etc...

Here is my logic and for some reason it is not working...
There is more code above which gets the next environment and version name, I just figured I didn't need to include that....

<?php if ($strEnv === $lastStrEnv && $strVer === $lastStrVersion) {?>
//Details only since its same env
<?php }
else {?>
//Write new env name version and details...
<?php }

//Place values into var holder..
$lastStrVersion = $strVer;
$lastStrEnv = $strEnv;
?>

<?php $rs->MoveNext();
} ?>


Any help would be appreciated
Thanks,

[JayM]

What you posted tells us nothing :(. You need to post your more. Also, describe why it's not working.

Are you getting an error? Is it displaying the environment more than once? What's happening? You have to let us know as much as possible because we can't see the program infront of us. :)

[mattv10]

Sorry.. That was the one part I forgot to talk about.. It is writing the environment name multiple rather than writing it once and placing all the errors inside the one cell..

That is the issue I am getting.. Hopefully that is enough..