Efwis Posted January 16, 2007 Share Posted January 16, 2007 hi gang,If this is posted in the wrong area, would a Mod please move it to the correct area.hopefully someone can help me out here. not sure if this is strictly MySQL queries or if it is handled strictly in the PHP code. This is what I got going on.I'm making a website with PHP and MySQL where up to 3 different bidders can bid on the same project. here is my basic layout.table1 table2 table3bidders customers bidder, customer, priceok now table1 and table2 will already exist, what I plan on doing is using PHP to allow the bidder to place a bid on the customers project. Upon clicking on a submit button in the PHP file, table3 will have bidderName, customerName and bidPrice inserted into it. The PHP code will already be calling the information from table2 and upon the bidder placing his/her bid, their info will be pulled from table1, then combined with table2, to create table3 info. so that the printout would look like this.I know the columns in table3 will be bidderNamecustomerNamebidPricebidderName place a bid on customerName project for bidPrice. I know it won't look like this on the actual printout. It will look as followsbidder: bidderNameproject: customerNameprice: $x.xxI hope your not lost on this.i am also wondering if there is a way to automatically remove the customerName after 3 bidders have placed their bids. Quote Link to comment Share on other sites More sharing options...
Nameless12 Posted January 16, 2007 Share Posted January 16, 2007 the answer to this is triggers if i understand you correctly I dont have time to explain them just do a wikipedia search and you should understand them fine Quote Link to comment Share on other sites More sharing options...
Efwis Posted January 16, 2007 Author Share Posted January 16, 2007 [quote author=Nameless12 link=topic=122599.msg505827#msg505827 date=1168923030]the answer to this is triggers if i understand you correctly I dont have time to explain them just do a wikipedia search and you should understand them fine[/quote]now we run into a problem.The triggers work on MySQL version 5.0.2 and up, the server that this will be going onto still runs MySQL version 4.1.21 and I have no control or way to make them upgrade the version.Therefore I need a way to do this that doesn't require triggers. Is it possible to make a PHP file do this? Quote Link to comment Share on other sites More sharing options...
Efwis Posted January 17, 2007 Author Share Posted January 17, 2007 *bump* Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.