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 table3 bidders customers bidder, customer, price ok 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 bidderName customerName bidPrice bidderName place a bid on customerName project for bidPrice. I know it won't look like this on the actual printout. It will look as follows bidder: bidderName project: customerName price: $x.xx I 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.