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

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,

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to