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. Link to comment https://forums.phpfreaks.com/topic/16774-is-select-the-right-command/ 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' Link to comment https://forums.phpfreaks.com/topic/16774-is-select-the-right-command/#findComment-70568 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? Link to comment https://forums.phpfreaks.com/topic/16774-is-select-the-right-command/#findComment-70620 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.