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)
teeraAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
VoteyDiscipleConnect With a Mentor Commented:
I'm not even sure what you're asking.  It seems like you want the difference between 'onhand' found on two different dates, yet the example you gave there doesn't seem to reflect that?

If that is what you want, which two dates?  How many dates are listed for each item?  Do you want the difference between each pair, or just the difference from the earliest record to the most recent?
0
 
teeraAuthor Commented:
Hi  VoteyDisciple
you are right that is the think I want can I use sql command only or I need to use php
0
All Courses

From novice to tech pro — start learning today.