Jump to content


Is SELECT the right command

  • Please log in to reply
2 replies to this topic

#1 kenwvs

  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts

Posted 07 August 2006 - 09:38 AM

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.

#2 alecjw

  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationHatfield, Herts, UK

Posted 07 August 2006 - 10:25 AM

UPDATE tablename WHERE criteria SET description='$decription'

#3 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 07 August 2006 - 12:40 PM

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?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users