Parse error

[JMadrix]

hmm... Error.

Parse error: parse error, expecting ','' or';'' in /usr/local/apache/htdocs/newstore/checkout2.php on line 108

I checked out line 108... It's:

$deletecoupon = mysql_query("DELETE FROM `couponcodes` WHERE `code` = '".$_SESSION['couponcode']."' LIMIT 1") or die(mysql_error());

Am I missing anything?

[mtmosier]

What's on the line before it?

[JMadrix]

Here's the section around the line:

$_SESSION['couponcode'] = $_REQUEST['couponcode']; //if your not sure whether the form uses GET or POST, use this one, this should always work.

//$subtotal = $HTTP_POST_VARS["subtotal2"]; don't pass -- pull from database
$shipping = $HTTP_POST_VARS["shipping"];

//$total = $HTTP_POST_VARS["total2"]; don't pass -- calculate from data 
$couponquery = "SELECT * FROM `couponcodes` WHERE `code` = '".$_SESSION['couponcode']."' LIMIT 1";
if(mysql_num_rows($couponquery) == 1)
   {
      $totaltopay = ($total * 0.8);
      echo "Valid Coupon Code: Deducted 20% from Total.<br />"
      $deletecoupon = mysql_query("DELETE FROM `couponcodes` WHERE `code` = '".$_SESSION['couponcode']."' LIMIT 1") or die(mysql_error());
   }
else
   {
      $totaltopay = $total;
   } 
//$amount = $HTTP_POST_VARS["amount"];
$comment = $HTTP_POST_VARS["comment"];

[mtmosier]

You're missing a semi-colon.

echo "Valid Coupon Code: Deducted 20% from Total.<br />" 

[JMadrix]

Well that helped... Got me past that error... Now I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/newstore/checkout2.php on line 104

I just can't win... :\

[mtmosier]

You never actually ran $couponquery, so you can't get the num of rows for it. mysql_num_rows takes the resource returned by mysql_query as a parameter.

[JMadrix]

So how do I "run" $couponquery?

I'm really new to PHP... I've been on forums for the last couple weeks trying to figure this out and I'm really close.

[mtmosier]

To run the query you would use mysql_query. If you're new to php you would do well to become intimately familiar with the manual.