Jump to content


Photo

Query of multiple items in one column


  • Please log in to reply
No replies to this topic

#1 kenwvs

kenwvs
  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts

Posted 03 September 2006 - 03:46 AM

I have a form that is filled out and there is one area where they fill in p to seven fields with a part number and then a description in another field.  I have designed a table that has one column for the part number and another column for the part description.  I am not sure how, using a mysql query, to get the information into the database since there is seven rows to be listed.  (if I had seven columns to match up, I know what to do, but with only one column I am not sure)

Would I just list the column name seven times in the query?  I am thinking that wouldn't work and there is a better way of doing it.

Ken




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users