Jump to content

Archived

This topic is now archived and is closed to further replies.

kenwvs

Is SELECT the right command

Recommended Posts

I have a form that has been filled out, and then stored in a DB and now another person (the boss) wants to review the form, and add comments and a purchase order #(that wasn't available on original form).  Other than adding the purchase order # and comments the forms will be identical.  Is it the SELECT query that I would want to use to get all the data back into the form?  None of the original data will be changed, just the 2 new fields will be added to the DB when he is done reviewing it.  He will know the work order # and this is what will be used to SELECT the proper record.

Share this post


Link to post
Share on other sites
try:
UPDATE tablename WHERE criteria SET description='$decription'

Share this post


Link to post
Share on other sites
Well, yes, you should populate the form from a SELECT query -- what other choice would you have?  And I guess you'll simply be updating the 2 new fields.  Maybe I missed the question?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.