Ideas?? (OT- MySQL)
| From: | Website4S at aol dot com | Date: | Thu, 25 Jan 2001 04:53:11 +0000 |
| Subject: | Ideas?? (OT- MySQL) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-36564@lists.php.net to get a copy of this message | ||
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