I am not sure if this is possible or not or in what
format etc.  Maybe it's a PHP, mysql or even a
JavaScript thing.  But thought I'd post here and see
if people are aware if it is possible for what I want
to do.  I have searched alot on the net and yet have
not come accross what I am looking for, so posting
here may get me pointed in the right direction.  Okay
here is what I wanna do. :)

I have a list of users in multiple tables in the one
database.  Each user has a field named 'score'.  As
the table numbers go higher generally the score goes
higher but never lower than the previous table.  There
are 22 tables named 1 to 22.  So an example is below:

table 1:
User: bob
Score: 7

table 2:
User: bob
Score: 10

table 3:
User: bob
Score: 16


So the scores go up and never down from the previous
table value.  Now what I want to output on a page is
not 7, 10, 16 but output the difference from the
current table and the table before it.  So obviously
table 1 would not be changed from 7 but table 2 would
need to output 3 and table 3 would output 6.  So I
need to output not the value but the difference
between the current table and the table before it and
if there is no table before it the value would be the
same or in other words the value minus 0.

Is there either a mysql query I can use for this or
would I use a JavaScript bit of code to work out the
difference and output it?

The code will need to connect to the database and
retrieve values and users from all 22 tables and cores
and somehow output the difference, is this possible?

Table 22 has the total amount after all tables, So I
don't need a total figure worked out.  (E.G. Aadding
all the scores together)

Is it possible, or a bit complicated?

I know this is a bit of a pain but already the scores
have been worked out, I should of created another
field to get the table score for that round from the
start and keep it but I did not think of that earlier
in the year.

If it's tto much work I wont bother about it, but
thought I'd ask and see if anyone can help.



http://search.yahoo.com.au - Yahoo! Search
- Looking for more? Try the new Yahoo! Search

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to