Hi,
I am creating a web site which allows users to post projects and then others
to place bids. I am setting up two tables in MySQL 'Projects' & 'Bids' my
problem is how best to cross reference. What I was thinking of doing is
creating a number of fields in the Projects table...
Bid1
Bid2
Bid3
etc
and then inserting the BidID from the bids table into Bid1, and if that is
already used then it will go into Bid2. But how many Bid# shall I create??
I`m sure there must be a faster method than this, anyone have any
suggestions??
TIA
Ade
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
