PHP MYSQL SUM Until a row then stop -

basically creating sort of checking account type query. easy except want split pages.

so have field called amount , can positive or negative number.

the problem if on records 75-100 need have query sum of amount until record 75 , give me total. can run query records 75-100 , loop through amounts so: (supposing sum , including 74 $500)

record#    amount    total 75         25.00     525.00 76         35.00     560.00 77         40.00     600.00  etc. 

what thinking idnum record 75 , sum until finds so: sum(case when idnum != $until amount else 0 end)

however keeps going. doesn't stop @ 75 skips 75 sums 76, 77, etc.. appreciated.

set @total=0; select      recordno,       amount,          @total:= @total+ amount total table1  limit 75, 75 

or

select        cur.id, cur.amount, sum(prev.amount) table1 cur left join table1 prev     on cur.id >= prev.id group cur.id  limit 75, 75 

here limit function start records 76 75 records, can send parameter