[Resolved] having problems problably something dumb that I'm just not seeing.

airric

I'm trouble getting my cart updating the qantity if the item already exists! I've been try different things and nothing seems to do it! Here is what I have.

if ($submitadd) {

$sql1 = mysql_query("SELECT * FROM carts WHERE userid=$userid AND davisid=$dvd_field_6");
$result1 = mysql_num_rows($sql1);

if (result1 >1 OR result1 ==1){
$query = "update carts SET qtty='$qtty' WHERE davisid=$dvd_field_6 AND userid=$userid";
$result = @($query);

} ELSE {

$sql = mysql_query("INSERT INTO carts(userid, davisid, title, price, qtty) VALUES ('$userid','$dvd_field_6', '$dvd_field_0', '$dvd_field_9', '$dvd_qtty')") or die (mysql_error());
$result = mysql_query($sql);
echo $result1;
}

echo "<td></td><td><a href=\"cart.php\" class=style12>$dvd_field_1<br/>has been Added to your Cart!</font></a><br/>";
exit;
}

kingbear

the first thing I notice is the following line:

if(result1 >1 OR result1 ==1){

should be:

if($result1 >= 1){

you need a $ sign in front of a variable.

airric

Yup that was it! thanks, figured it was my eyes! LOL

However I have a NEW problem! with my updating of the qtty field i get a 0

if ($submitadd) {
$sql2 = mysql_query("SELECT qtty FROM carts WHERE userid=$userid AND davisid=$dvd_field_6");
$result2 = mysql_query($sql2);
while ($row = @mysql_fetch_array($result2))
{
$qty =$row[qtty] +1;

}
$sql1 = mysql_query("SELECT * FROM carts WHERE userid=$userid AND davisid=$dvd_field_6");
$result1 = mysql_num_rows($sql1);

if ($result1 >= 1){
$query = "update carts SET qtty='$qty' WHERE davisid=$dvd_field_6 AND userid=$userid";
$result = @($query);

}

airric

I tried this:

while ($row = @mysql_fetch_array($result2))
{
$num =$row[qtty];
$qty=$num +1;

and it pulls the qtty but doesn't add the 1 to the field??