Re: [PHP] Ideas?? (OT- MySQL)

Thanks for the input, I have turned it around now as you said and recorded the projectID in the bid table rather than the other way round. Cheers Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [PHP] Ideas?? (OT- MySQL)

You will probably be much happier in the future if you make a one-to-many setup rather than a many-to-many. As Mathew said, create your tables with: BID table: bidid, projectid, OtherFields PROJECT table: projectid, OtherFields If you are at a project and want to look at bids, just "select * f

Re: [PHP] Ideas?? (OT- MySQL)

<[EMAIL PROTECTED]> wrote ... > 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 Pr

[PHP] Ideas?? (OT- MySQL)

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