Jump to content


Newbie : Array Field


  • Please log in to reply
1 reply to this topic

#1 Guest_yoruldum_*

Guest_yoruldum_*
  • Guests

Posted 28 November 2003 - 01:54 AM

Hi there,
I have a problem as you can imagine :)

There is a table which has a list of products.For example we are buying product A from 3 suppliers and product B from 5 suppliers which of 2 suppliers are same. I want to have ability to search this table like \"SELECT * FROM products WHERE product_name = \'A\'\" and fetch suppliers name from that dataset. If I create one field called suppliers and add values like \"supp1,supp2,supp3\" than the result will be one string and I have to parse these one by one.

Is there any easier way for that freaks :lol:

#2 sirmanson

sirmanson
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationTucson, AZ USA

Posted 02 December 2003 - 03:36 PM

You should probably create another table that just keeps track of which suppliers stock which products. Since you have a \"many-to-many\" relationship it should not be stored with your products.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users