But qty,price must get so:INSERT INTO soldItems(itemId,qty,price,buyer,date,buyerStatus,sellerStatus,address,shipType,paymentType) VALUES('$i',XXX,XXX,'$user','$time','0','0','$shipType','$paymentType');
But with conditionsSELECT cart.qty, cart.qty*items.price as price FROM cart,items WHERE cart.user='$user' AND cart.itemId='$i' AND items.id='$i';
ANDSELECT IF( EXISTS( SELECT * FROM delivery WHERE deliveryId='$shipType' AND itemId='$i'), 1, 0)
it sould be in one querySELECT IF( EXISTS( SELECT * FROM paymentType WHERE шd='$paymentType' AND itemId='$i'), 1, 0)