How to use AutoIncrement: ID from one table in another

[34534534534555]

Hi

I am inserting a record into table: Auction, which has an auto increment field -auctionid. I then want to use this auction.auctionid in the table: Bid, how can i do this?This is my code, and what i want to do!!

$query ="INSERT INTO auction
				(sellerusername, isbn, status, bookcondition, buyitnow)
			VALUES
				('$username', '$isbn', 'open', '$bookcondition', '$buyitnowprice')";
	
	$query1 ="INSERT INTO bid
				(auctionid, bidprice, bidusername)
			 VALUES
				(LAST_INSERT_ID(auctionid), '$startprice', '$username')";
	
	$sql = mysql_query($query) or die("Invalid query: " . mysql_error()); 
	$sql = mysql_query($query1) or die("Invalid query: " . mysql_error());

TIA


| Feedback is always appreciated as this will help to further our knowledge as well |

 

[hos2]

$query ="INSERT INTO auction
                (sellerusername, isbn, status, bookcondition, buyitnow)
            VALUES
                ('$username', '$isbn', 'open', '$bookcondition', '$buyitnowprice')";
    	$auctionid=mysql_insert_id();
    $query1 ="INSERT INTO bid
                (auctionid, bidprice, bidusername)
             VALUES
                (LAST_INSERT_ID(auctionid), '$startprice', '$username')";
    
    $sql = mysql_query($query) or die("Invalid query: " . mysql_error()); 
    $sql = mysql_query($query1) or die("Invalid query: " . mysql_error());

with $auctionid=mysql_insert_id();

 

[cdlvj]

Keep in mind that in a multi-processing environment, auto increment does not work. Mysql gets all confused. Not sure if it has been fixed.