Print Web Content

function current_balance($val,$val1,$val2)
{
$conn = mysql_connect("localhost", "root", "") or die(mysql_error());
// echo "$conn";
mysql_select_db("stationary_requisition",$conn);

$sql="Select SUM(quantity) from purchage where i_code=$val && date>="."'".$val1."'"." && date<="."'".$val2."'".";" ;
//echo "$sql";
$result = mysql_query($sql, $conn)or die(mysql_error());
while ($item1 = mysql_fetch_row($result))
//echo $item1[0];
$sum=$item1[0];
//echo $sum;

$sql="Select SUM(quantity) from item_table where i_code=$val && date>="."'".$val1."'"." && date<="."'".$val2."'".";" ;
//echo "$sql";
$result = mysql_query($sql, $conn)or die(mysql_error());
while ($item2 = mysql_fetch_row($result))
//echo $item2[0];
$sum1=$item2[0];

//echo "
";

//$sum= $item1[0]+$item2[0];

//echo $sum;


//echo $sum;
//echo $sum1;
$sum2=$sum+$sum1;
//echo "
";
//echo "open=".$sum."purchage=".$sum2;
$sql="Select SUM(quantity) from place_requisition where i_code=$val && delivery_status='delivered'". "&& date>="."'".$val1."'"." && date<="."'".$val2."'".";" ;
//echo "$sql";
$result = mysql_query($sql, $conn)or die(mysql_error());
while ($item3 = mysql_fetch_row($result))
$issue=$item3[0];
$balance=$sum2-$issue;
echo $balance;


}


?>

WelCome ..
Add/Update Item Place Requisition Requisition Delivery Report See The Status	Closing Balance From : To : $str= $_POST["f_date"]; //$str="12/01/2008"; $str1=substr($str,0,2); $str2=substr($str,3,2); $str3=substr($str,6,4); $f_date=$str3."-".$str2."-".$str1; $str11= $_POST["t_date"]; //$str="12/01/2008"; $str6=substr($str11,0,2); $str7=substr($str11,3,2); $str8=substr($str11,6,4); $t_date=$str8."-".$str7."-".$str6; //echo $c_date; ?> $item_per_page = 25; $page = 1; if($_REQUEST['page']) { $page = $_REQUEST['page']; } $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("stationary_requisition",$conn); $sql="Select * from item_table;" ; $result = mysql_query($sql); $total = mysql_num_rows($result); $num_of_page = ceil($total/$item_per_page); $start = ($page-1)*$item_per_page; $count = $item_per_page; $sql="Select * from item_table limit ".$start.",".$count.";" ; //echo "$sql"; $result = mysql_query($sql, $conn)or die(mysql_error()); $i=1; while ($item = mysql_fetch_row($result)) { ?> } ?> Item Name Item Code Opening Balance Closing Balance //test(); ?> for ($i=1;$i<=$num_of_page;$i++) { echo '' .$i. ' '; } ?>
echo ""; ?>