On Monday 11 November 2002 21:48, Martin Allan Jensen wrote: > Okey people, i try again....!! > > I have a table in a mysql database that holds this: > +----+--------+------------+--------+------+ > > | id | maaler | aflaest | vaerdi | pris | > > +----+--------+------------+--------+------+ > > | 21 | 11 | 2002-01-01 | 15160 | 0.00 | > | 22 | 11 | 2002-02-01 | 15180 | 0.00 | > | 23 | 11 | 2002-03-01 | 15200 | 0.00 | > | 24 | 11 | 2002-04-01 | 15240 | 0.00 | > | 25 | 11 | 2002-05-01 | 15250 | 0.00 | > | 27 | 10 | 2002-11-14 | 210 | 0.00 | > | 30 | 10 | 2002-12-19 | 230 | 0.00 | > > +----+--------+------------+--------+------+ > > Each "maaler" have it's own start registration witch is: > +----+----------+-------+ > > | id | nummer | start | > > +----+----------+-------+ > > | 10 | 56456 | 200 | > | 11 | 000002 | 15150 | > > +----+----------+-------+ I still don't understand what you're doing :-/ > I then made a script that takes "start" for each "maaler" if it have any > registrations. Then it does this: if its first field then it takes the > "vaerdi"(THE VALUE) and - it with the "start" (THE STARTREGISTRATION) For > the next fields it takes the "vaerdi" - the last "vaerdi". My problem is > that after the script has ran it have lets say 20 yeas 2002 (the > registration year called "aflaest" in the table) and lets say two 2003. But why are you keeping all those transient values ... > I only need ONE value "vaerdi" per year, witch is the one it just calculated ... why don't you just keep the 'latest' value -- which should be the maximum value? > in a loop. But it have all the values and years in the array. How do i only > take ONE value per year in PHP NOT SQL?? > > I really hope this is discriping enough....!! -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* A lot of people are afraid of heights. Not me. I'm afraid of widths. -- Steven Wright */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
