Code: Select all
$query = "SELECT * FROM TblBasket";
$result = mysql_query ($query);
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
if ($row[id] = $item AND $row[userEmail] = $Busername){
$qunt = $row[qun];
$qunt = $qunt + 1;
$query = "UPDATE TblBasket SET qun = $qunt WHERE id = '$item'";
$result = mysql_query($query) or die(mysql_error());
}
else{
$query = "INSERT INTO TblBasket (id, userEmail, itemId, CartDate) VALUES ('NULL','$Busername','$item', NOW())";
$result = mysql_query ($query);
}
}
else add a new item..
my code above not working..
can some1 plz help