Balwant,
Right now this is an algorithm question, not a PHP or MySQL problem.
Define exactly what you want to see as output, what you have as inputs, and what process you would have to follow to achieve the output.
But don't "suppose" - be specific.
Then it's possible to fit it to a language: maybe all the processing could be done in the SELECT statement, maybe some will have to be done after the results are returned.
Regards - Miles Thompson
At 12:42 AM 12/22/2004, Balwant Singh wrote:
hi to all,
may somebody guide me on the following:
I want to retrieve data from MYSQL and then want that PHP do calculation - substract a particular field from its previous row. i.e. suppose i have two field named DATE, STOCK and have 10 rows. Now i want that STOCK on the 10th row should be substracted from 9th and so on. May pls. help me.
with best wishes balwant
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
