[JackOfAllTrades]

How about instead of writing the data out in HTML, you create a CSV string for each row? Seems logical, eh?

[baavgai]

Brute force, cut and paste all the way, huh? And CSS out the window. If this was clean XHTML you could just transform your output into CSV with some XSL. But let's look at pure PHP options. It's really just a question of how you offer your output. Unfortunately, you don't use anything remotely like functions. The continuous code as one stream of consciousness is very hard to modify.

Let's take a look at this bit:

while($rowAttendanceTotals = mysql_fetch_array($resultAttendanceTotals)) {
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>" . trim($rowAttendanceTotals['Totals_Present']) . "</td>";
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;' >" . trim($rowAttendanceTotals['Totals_PublicHoliday']) . "</td>";
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>" . trim($rowAttendanceTotals['Totals_ApprovedLeave']) . "</td>";
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>" . trim($rowAttendanceTotals['Totals_SickLeave']) . "</td>";
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>" . trim($rowAttendanceTotals['Totals_OtherAbsence']) . "</td>";
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>" . trim($rowAttendanceTotals['Totals_Leave']) . "</td>";
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>" . trim($rowAttendanceTotals['Totals_Holiday']) . "</td>";
	
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'><b>" . trim($rowAttendanceTotals['Totals']) . "</b></td>";
}

First, lets clean that up a bit:

function showFieldTR($value, $isBold) {
	echo "<td align='center' style='writing-mode: tb; font-family:verdana; font-size: 70%;'>";
	if ($isBold) { echo "<b>"; }
	echo $value;
	if ($isBold) { echo "</b>"; }
	echo "</td>";
}

function showAttendanceTotalsTR($row) {
	$fields = array('Totals_Present','Totals_PublicHoliday','Totals_ApprovedLeave', 'Totals_SickLeave','Totals_OtherAbsence','Totals_Leave','Totals_Holiday');
	echo "<tr>";
	foreach ($fields as $field) { showFieldTR(trim($row[$field]), false); }
	showFieldTR(trim($row['Totals']), true);
	echo "</tr>";
}

//...
while($rowAttendanceTotals = mysql_fetch_array($resultAttendanceTotals)) {
	showAttendanceTotalsTR($rowAttendanceTotals)
}

What does this buy you, besides lack of repeating code? Well, for CSV, you'd just do this:

function showAttendanceTotalsCSV($row) {
	$fields = array('Totals_Present','Totals_PublicHoliday','Totals_ApprovedLeave', 'Totals_SickLeave','Totals_OtherAbsence','Totals_Leave','Totals_Holiday');
	
	foreach ($fields as $field) { echo trim($row[$field]).','; }
	echo trim($row['Totals']) . "\n";
}

//...
while($rowAttendanceTotals = mysql_fetch_array($resultAttendanceTotals)) {
	showAttendanceTotalsCSV($rowAttendanceTotals)
}

I know you didn't ask about it, but that SQL... ouch. Let's look at one, all cleaned up:

$SQLAttendanceTotals="SELECT
		Count_Totals.EmpId,
		CASE WHEN Count_Present.Totals_Present IS NULL THEN 0 ELSE Count_Present.Totals_Present END AS Totals_Present,
		CASE WHEN Count_PublicHoliday.Totals_PublicHoliday IS NULL THEN 0 ELSE Count_PublicHoliday.Totals_PublicHoliday END AS Totals_PublicHoliday,
		CASE WHEN Count_ApprovedLeave.Totals_ApprovedLeave IS NULL THEN 0 ELSE Count_ApprovedLeave.Totals_ApprovedLeave END AS Totals_ApprovedLeave,
		CASE WHEN Count_SickLeave.Totals_SickLeave IS NULL THEN 0 ELSE Count_SickLeave.Totals_SickLeave END AS Totals_SickLeave,
		CASE WHEN Count_OtherAbsence.Totals_OtherAbsence IS NULL THEN 0 ELSE Count_OtherAbsence.Totals_OtherAbsence END AS Totals_OtherAbsence, 
		CASE WHEN Count_Leave.Totals_Leave IS NULL THEN 0 ELSE Count_Leave.Totals_Leave END AS Totals_Leave,
		CASE WHEN Count_Holiday.Totals_Holiday IS NULL THEN 0 ELSE Count_Holiday.Totals_Holiday END AS Totals_Holiday,
		CASE WHEN Count_Attendance.Totals_Attendance IS NULL THEN 0 ELSE Count_Attendance.Totals_Attendance END AS Totals	
	FROM (
		select EmpId, count(EmpId) As Totals 
			from UserDetails 
			WHERE EmpId = '$TemEmpId' 
			GROUP BY EmpId
		) Count_Totals
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_Present 
				from attendance 
				WHERE MarkType = 'PR' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) Count_Present 
				ON Count_Totals.EmpId = Count_Present.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_PublicHoliday 
				from attendance
				WHERE MarkType = 'AB' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) Count_PublicHoliday 
				ON Count_Totals.EmpId = Count_PublicHoliday.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_ApprovedLeave 
				from attendance
				WHERE MarkType = 'PL' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) Count_ApprovedLeave  
				ON Count_Totals.EmpId = Count_ApprovedLeave.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_SickLeave 
				from attendance
				WHERE MarkType = 'SL' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
					GROUP BY EmpId
			) Count_SickLeave 
				ON Count_Totals.EmpId = Count_SickLeave.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_OtherAbsence 
				from attendance 
				WHERE MarkType = 'CO' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) Count_OtherAbsence 
				ON Count_Totals.EmpId = Count_OtherAbsence.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_Leave 
				from attendance
				WHERE MarkType = 'CL' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) Count_Leave 
				ON Count_Totals.EmpId = Count_Leave.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_Holiday 
				from attendance 
				WHERE MarkType = 'HO' 
					AND EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate'
					GROUP BY EmpId
			) Count_Holiday 
				ON Count_Totals.EmpId = Count_Holiday.EmpId
		LEFT JOIN (
			select EmpId,count(MarkType) As Totals_Attendance 
				from attendance
				WHERE EmpId='$TemEmpId'
					AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) Count_Attendance 
				ON Count_Totals.EmpId = Count_Attendance.EmpId
";

Do you see repetition? You goal should alway be to identify and eliminate repetitive patterns. You already know how to use a case statement. Use it to your advantage. Also, look into IFNULL: http://dev.mysql.com...function_ifnull

$SQLAttendanceTotals="SELECT
		Count_Totals.EmpId,
		CASE WHEN IFNULL(AttTotals.Present,0) AS Totals_Present,
		CASE WHEN IFNULL(AttTotals.PublicHoliday,0) AS AS Totals_PublicHoliday,
		CASE WHEN IFNULL(AttTotals.ApprovedLeave,0) AS Totals_ApprovedLeave,
		CASE WHEN IFNULL(AttTotals.SickLeave,0) AS Totals_SickLeave,
		CASE WHEN IFNULL(AttTotals.OtherAbsence,0) AS Totals_OtherAbsence, 
		CASE WHEN IFNULL(AttTotals.Leave,0) AS Totals_Leave,
		CASE WHEN IFNULL(AttTotals.Holiday,0) AS Totals_Holiday,
		CASE WHEN IFNULL(AttTotals.Attendance,0) AS Totals
	FROM (
		select EmpId, count(EmpId) As Totals 
			from UserDetails 
			WHERE EmpId = '$TemEmpId' 
			GROUP BY EmpId
		) Count_Totals
		LEFT JOIN (
			select EmpId, 
					sum(CASE WHEN MarkType = 'PR' THEN 1 ELSE 0 END) AS As Present,
					sum(CASE WHEN MarkType = 'AB' THEN 1 ELSE 0 END) AS As PublicHoliday,
					sum(CASE WHEN MarkType = 'PL' THEN 1 ELSE 0 END) AS As ApprovedLeave,
					sum(CASE WHEN MarkType = 'SL' THEN 1 ELSE 0 END) AS As SickLeave,
					sum(CASE WHEN MarkType = 'CO' THEN 1 ELSE 0 END) AS As OtherAbsence,
					sum(CASE WHEN MarkType = 'CL' THEN 1 ELSE 0 END) AS As Leave,
					count(MarkType) As Attendance
				from attendance 
				WHERE EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
				GROUP BY EmpId
			) AttTotals
				ON Count_Totals.EmpId = AttTotals.EmpId
				
";

Even this seems moderately redundatnt, since you don't actually use Totals from the other query. You could just go with the one select:

select EmpId, 
		sum(CASE WHEN MarkType = 'PR' THEN 1 ELSE 0 END) AS As Present,
		sum(CASE WHEN MarkType = 'AB' THEN 1 ELSE 0 END) AS As PublicHoliday,
		sum(CASE WHEN MarkType = 'PL' THEN 1 ELSE 0 END) AS As ApprovedLeave,
		sum(CASE WHEN MarkType = 'SL' THEN 1 ELSE 0 END) AS As SickLeave,
		sum(CASE WHEN MarkType = 'CO' THEN 1 ELSE 0 END) AS As OtherAbsence,
		sum(CASE WHEN MarkType = 'CL' THEN 1 ELSE 0 END) AS As Leave,
		count(MarkType) As Attendance
	from attendance 
	WHERE EmpId='$TemEmpId' AND Date Between '$AttendanceFromDate' AND '$AttendanceToDate' 
	GROUP BY EmpId

Hope this helps.