MrTV
asked on
check the product change in mysql
00001 0 2006-11-15 20:54:05
00002 2 2006-11-15 20:54:05
00012 4 2006-11-15 20:54:05
00001 4 2006-12-15 20:54:05
00002 3 2006-12-15 20:54:05
00003 2 2006-12-15 20:54:05
three colum above name code,onhand,time
how can I write code to caculate onhand change (if some code nohave onhand give it equal to 0)
00003 2
00002 1
00001 4
00012 -4 (if some code nohave onhand give it equal to 0)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
you are right that is the think I want can I use sql command only or I need to use php