i have this following coding

[NadiahYayah]

hello... my name is nadiah.. i have this following coding.. i want to sum a row from mysql after selected few data or record i want..

<?php
	session_start();
	$date = date ('Y-m-d');
	$filename = "Report For ".$date."xls"; 

header("Expires: Sat, 01 Jan 2000 00:00:00 GMT"); 
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT"); 
header("Pragma: public"); 
header("Expires: 0"); 
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Cache-Control: public"); 
header("Content-Description: File Transfer"); 

session_cache_limiter("must-revalidate"); 
header("Content-Type: application/vnd.ms-excel"); 
header('Content-Disposition: attachment; filename="' . $filename .'"'); 

//session_start();
//$date = date('Ymd');

$linkdb = mysql_connect("localhost","root","");
	if(!$linkdb){
		echo "Unable to connect database".mysql_error();
		exit();
	}else{
		//echo "Congratulation! Welcome to my database";
	}
	$selectdb = mysql_select_db("temp");
	if(!$selectdb){
		echo "Unable to select database".mysql_error();
		exit();
	}else{
		//echo "Successfully select database";
	}

?>
<table border="1">
	<tr bgcolor="blue">
		<td>Name</td>
		<td>IC No.</td>
		<td>Loan No.</td>
		<td>Collection Amount</td>
		<td>KFH Amount</td>
		<td>Coshare Amount</td>
	</tr>
<?php

if (isset($_POST['Submit'])) {
$print = $_POST["print"];
$countrow = count($print);

for ($i=0; $i<$countrow; $i++) {
	$sql = "SELECT *, SUM(Recon_CollectionAmt) FROM recon_list WHERE (Recon_CSHNo='{$print[$i]}') AND Recon_Flag='RECON' ";
	$result = mysql_query($sql);

	//$sqla = "SELECT SUM(Recon_CollectionAmt) FROM recon_list WHERE (Recon_CSHNo='{$print[$i]}') AND Recon_Flag='RECON' ";
	//$resulta = mysql_query($sqla);
	// Print out result
	//	while($row = mysql_fetch_array($resulta)){
	//	echo "Total Collection : RM". $row['SUM(Recon_CollectionAmt)'];
	//	echo "<br />";
	//	}

	while($_POST = mysql_fetch_array($result)){
	$date = date('Ymd');

	if(!$result){
			}else{
				$sql1 = "UPDATE recon_list SET Recon_Flag='RECON ON $date' WHERE (Recon_CSHNo='{$print[$i]}') AND Recon_Flag='RECON' ";

				$querydata = mysql_query($sql1);
					if(!$querydata){
						echo "RECORDS CANNOT BE INSERT".mysql_error();
					}else{

					};
			}
?>
		<tr>
			<td><?php echo  $_POST ['Recon_Name'] ?></td>
			<td><?php echo $_POST ['Recon_ICNo'] ?></td>
			<td><?php echo $_POST ['Recon_BankRefNo'] ?></td>
			<td><?php echo $_POST ['Recon_CollectionAmt'] ?></td>
			<td><?php echo $_POST ['Recon_KFHAmt'] ?></td>
			<td><?php echo $_POST ['Recon_CoshareAmt'] ?></td>
		</tr>


<?php
		} // close while
	}//close for
}//close if isset	

?>
	</table>

[Lord_Yggdrasill]

So what is the problem you are having? If you receive any specific error messages, post them here. If you are looking for critiques, post your codes in the code critiques section.

[NadiahYayah]

an excel report can be generate.. but for the numbering fields and amound fields... it does not change automatically... can u assist me? for numbering, i will represent something like 7.281E+... something like that..

[Damian_]

I think i know what you mean, I had a problem where i separated each user with the date in numbers followed by "." and a random number.

everytime i exported it into a spreadsheet the numbers were formatted by excel kept round up the numbers and shortening my uniqueid, this was extremely frustrating.

the only thing i could do was open spreadsheet and import via database, but i selected the column which was for uniqueid to text formatted.

Have tried placing this single quote before the numbers ( ' ) see if that works? trick the worksheet into thinking it is text?

[NadiahYayah]

Damian_;11001384 wrote:

I think i know what you mean, I had a problem where i separated each user with the date in numbers followed by "." and a random number.

everytime i exported it into a spreadsheet the numbers were formatted by excel kept round up the numbers and shortening my uniqueid, this was extremely frustrating.

the only thing i could do was open spreadsheet and import via database, but i selected the column which was for uniqueid to text formatted.

Have tried placing this single quote before the numbers ( ' ) see if that works? trick the worksheet into thinking it is text?

yeah... tried it... thanks a lot there... it help me lots....

[NadiahYayah]

i have another question, can this sql select the latest record where there are more than 1 record per customer

SELECT * FROM tbl_selfpayment, tbl_shortpaid WHERE (SP_CustIC='$ic' AND SP_MonthPaid='$MonthPaid') AND (SPaid_CustIC='$ic' AND SPaid_MonthPaid='$MonthPaid') ASC LIMIT 1

[bradgrafelman]

Add an ORDER BY clause to order the results by whatever criteria that would make one the "latest" record.

[NadiahYayah]

bradgrafelman;11001507 wrote:

Add an ORDER BY clause to order the results by whatever criteria that would make one the "latest" record.

But i only need the latest one... not all of it

[bradgrafelman]

NadiahYayah;11001514 wrote:

But i only need the latest one... not all of it

... which is why you need to add an ORDER BY clause so that the latest result is on top when the LIMIT is applied.