kenwvs Posted August 7, 2006 Share Posted August 7, 2006 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. Quote Link to comment Share on other sites More sharing options...
alecjw Posted August 7, 2006 Share Posted August 7, 2006 try:UPDATE tablename WHERE criteria SET description='$decription' Quote Link to comment Share on other sites More sharing options...
fenway Posted August 7, 2006 Share Posted August 7, 2006 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.