JOINING? Would it be a join that I would use to get the 'cust_id' (auto-incremented from Mysql) from table CUSTOMER into the other tables of CARD PAYMENT & CUST ORDER. If so, how? Also, does this work even if they are queried at the same time?

// database connection
mysql_connect("$host","$user","$pass" );
// database selection

// Insert customer information
mysql_query("INSERT INTO customer VALUES(

// Insert payment
mysql_query("INSERT INTO card_payment VALUES(
'$total')" );

// Insert customer order
mysql_query("INSERT INTO cust_order VALUES(
'$cart_id')" );