Code: Select all
$connect = mysql_connect($db_server,$db_user,$db_pass);
if(!$connect)
{
die('Cannot connect to database. '.mysql_error());
}
mysql_select_db($db,$connect);
$query = "INSERT INTO carts (Product_ID, Amount, Account) VALUES (".$item_id.",1,'".$user."')";
mysql_query($query);
mysql_close($connect);
Product_ID is int(11)
Amount is int(11)
Account is text
Any help is appreciated