Updating a Grid of Data

My Setup: MySQL and PHP4. Two tables with one to many relationship: tblAccount (AccountId, AccountName, Comment) tblRates (RateId,GrossRate,AER,NetRate,AccountId(foreign key)). There are many rates per account. I need to provide a means for a user to loop through each element in tblRates updating as necessary. I suppose you could liken it to a spreadsheet, but clearly with limitations re: input boxes (names and values). I'm thinking along the lines of displaying a row at a time with a submit button - once clicked, an update query will run and the user will be presented with the next row. Seem ok - or would there be a better solution? Thanks for any input, Chris