[SOLVED] Parse Error in duplicate PHP

[NickG21]

Hey guys, i keep receiving this parse error of:

 

Parse error: syntax error, unexpected '"' in /.../order.php on line 13

 

Line 13 is as follows:

 

  	/*Get Products from Cart*/
Line 13:	$SQLCuCart = "SELECT CartPrID, CartPrQty from tblCart Where CartSessionID = '" . $_COOKIE["PHPSESSID"] . "'";
$rsSQLCuCart = mysql_query($SQLCuCart);
echo $SQLCuCart;

 

The real issue im having is that im using the exact same query on the page before which is a type of "Order Overview" page and everything is working perfectly.  I have been using this same method of querying throughout this project and it has worked fine the entire way until i made this order.php page.

Any insight would be excellent,

thank you,

NickG

[ignace]

Post the entire code please as that would work fine.

[NickG21]

Here's the entire page;

<?php
ini_set('display_errors', 1);
ini_set('log_errors', 1);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');
error_reporting(E_ALL);
include("header.inc.php");
foreach ($_POST as $key => $value) {
    $$key = $value;
    echo $$key;
  }
/*Update tblCustomer with CC Information*/
$sqlCCUpdate = "UPDATE tblCustomer set CuCCType = '" . $CCardType . "', CuCCNum = '" . $CCNum . "', CuCCSVC = '" . $CCCSV . "', CCExpDate= '" . $CCYear . "',CCName='" . $CCName . '" WHERE CuSessID = "' . $_COOKIE['PHPSESSID'] . '";
  	echo $sqlCCUpdate;
  	$rssqlCCUpdate = mysql_query($sqlCCUpdate);
  	
  	/*Get Products from Cart*/
Line 17 Error Line:     $SQLCuCart = "SELECT CartPrID, CartPrQty from tblCart Where CartSessionID = '" . $_COOKIE['PHPSESSID'] . "'";
	$rsSQLCuCart = mysql_query($SQLCuCart) or die("Query Unsuccesful using CartSessION");
	echo $SQLCuCart;
?>

<div id="content">
<table>
<?php
while($PrIDs = mysql_fetch_array($rsSQLCuCart)){
		$PrID = $PrIDs['CartPrID'];
		$ProdSQL = "SELECT PrName,PrImage,PrPrice from tblProduct where PrID ='$PrID'";	
		$rsProdSQL = mysql_query($sql) or die("No PrID associated");
		while($row = mysql_fetch_array($result)){
        		echo $row['PrName'];
			}
		}	



	?>
</table>
</div>		
<?php include("footer.inc.php"); ?>

[NickG21]

also i've tried other syntax for the same query that seemed to go through and i would get either an UNEXPECTED_T_STRING on the same line or the same Parse error on line 27, the query inside the while{} loop

thanks for your help,

[tbare]

it's the single quotes in

 

. $_COOKIE['PHPSESSID'] .

 

 

the first single quote is finishing the single quote before the .

[tbare]

... or rather start the query with a ' instead of a "

 

you have your singles and doubles reversed in the first query

[thebadbad]

You're mixing single and double quotes on the longest line, and missing a single quote in the second query. You should also run the variables through mysql_real_escape_string() before using them in a query.

[gevans]

This line

 

$sqlCCUpdate = "UPDATE tblCustomer set CuCCType = '" . $CCardType . "', CuCCNum = '" . $CCNum . "', CuCCSVC = '" . $CCCSV . "', CCExpDate= '" . $CCYear . "',CCName='" . $CCName . '" WHERE CuSessID = "' . $_COOKIE['PHPSESSID'] . '";

 

should be

 

$sqlCCUpdate = "UPDATE tblCustomer set CuCCType = '" . $CCardType . "', CuCCNum = '" . $CCNum . "', CuCCSVC = '" . $CCCSV . "', CCExpDate= '" . $CCYear . "',CCName='" . $CCName . '" WHERE CuSessID = '" . $_COOKIE['PHPSESSID'] . "'";

 

You had the single and double quotes the wrong way round and you needed the closing double quote.

 

EDIT: same problem in the query above it

[tbare]

first query fixed

 

$sqlCCUpdate = "UPDATE tblCustomer set CuCCType = '" . $CCardType . "', CuCCNum = '" . $CCNum . "', CuCCSVC = '" . $CCCSV . "', CCExpDate= '" . $CCYear . "',CCName='" . $CCName . "' WHERE CuSessID = '" . $_COOKIE['PHPSESSID'] . "'";

 

edit: oops... try now

[NickG21]

everything's working perfectly! thank you all for your help i appreciate it a ton! couldn't have done it without you (obviously!)