<?php session_start(); @mysql_connect('localhost','','') or die('please check username or password'); @mysql_select_db('') or die('error connetcing database'); $qry="select datediff(duedate, curdate()) xyz,id fresh_orders"; echo $qry; $rs=mysql_query($qry); $qry1=""; while($row=mysql_fetch_array($rs)) { echo $row[0]; echo $row[1]; $qry1="update fresh_orders set ddays='".$row[0]."' id=".$row[1].""; mysql_query($qry1); } ?> this formula not working me.
i want calculate difference between payment due date , current date , update remaining amount of days in ddays (due days) on every session login on individual user's login admin(my) side.
each client have different credit days need affect on each id together. there way can calculate difference of each id in 1 time login?
update fresh_orders set ddays=datediff(duedate, curdate())
Comments
Post a Comment