I want to simplify my current working form. Right now, it queries mysql server, works through the $result producing a <form> with <input>s and then a submit button that has the ?record=$rowid in the action. That all works. What I'd like is to get this down to a single form and a single submit button.
The schema on the table is:
ID - duh
truck - related to ID in dat_trucks table
ddate - the date in YYYY-mm-dd format (named it ddate back in Access days)
location - an enum with a few locations the trucks will be at
activity - an enum with a few things like "worked" and "idle"
I think a loop similar to what I am already doing, but tacking the ID of the current trk_use row into the form field names somehow. I'm right on the verge of getting this, but I have to admit, I'm not a real bright person. I good practical example would be nice (surely there's a good how-to link somewhere, I just can't seem to find it!).
Thanks in advance for any help, constructive criticism, or entertaining abuse!
----
JBR
The schema on the table is:
ID - duh
truck - related to ID in dat_trucks table
ddate - the date in YYYY-mm-dd format (named it ddate back in Access days
)location - an enum with a few locations the trucks will be at
activity - an enum with a few things like "worked" and "idle"
I think a loop similar to what I am already doing, but tacking the ID of the current trk_use row into the form field names somehow. I'm right on the verge of getting this, but I have to admit, I'm not a real bright person. I good practical example would be nice (surely there's a good how-to link somewhere, I just can't seem to find it!).
Thanks in advance for any help, constructive criticism, or entertaining abuse!
----
JBR