Parse error

supherman

Please help. I have seen allot of posts on this subject but I am ne and dont no what the problem is...?
I get the message:

Parse error: syntax error, unexpected $end in /home/furnitur/public_html/Templates/products.php on line 62

line 62 is the last line in my code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php



include("db.php");

// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("select * from products order by itemName asc");
?>



<?php
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td width="30%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
R
<?php echo $row["itemPrice"]; ?>
</font>
</td>
<td width="50%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=add_item&id=
<?php echo $row["itemId"]; ?>
&qty=1">Add Item</a>
</font>
</td>
</tr>
<tr>
<td width="100%" colspan="4">
<hr size="1"color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="100%" colspan="4">
<font face="verdana" size="1" color="black">
<a href="cart.php">Your Shopping Cart</a>
</font>
</td>
</tr>
</table>
</body>
</html>

jeepin81

You did not close your while loop. while () { .... }

<?php
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td width="30%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
R
<?php echo $row["itemPrice"]; ?>
</font>
</td>
<td width="50%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=add_item&id=
<?php echo $row["itemId"]; ?>
&qty=1">Add Item</a>
</font>
</td>
</tr>
<?php } ?>

see if that helps

supherman

thanx for the reply

I changed it. Now it sais:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/furnitur/public_html/Templates/products.php on line 18

I did a sql error report and it sais Error: No database selected... so I think it must be in the Database connect php script? Or am I wrong?

<?php

// This page contains the connection routine for the
// database as well as getting the ID of the cart, etc

$dbServer = "localhost";
$dbUser = "fddd";
$dbPass = "xxx";
$dbName = "fdd";

function ConnectToDb($server, $user, $pass, $database)
{
// Connect to the database and return
// true/false depending on whether or
// not a connection could be made.

$s = @mysql_connect($server, $user, $pass);
$d = @mysql_select_db($database, $s);

if(!$s || !$d)
return false;
else
return true;
}

function GetCartId()
{
// This function will generate an encrypted string and
// will set it as a cookie using set_cookie. This will
// also be used as the cookieId field in the cart table

if(isset($_COOKIE["cartId"]))
{
return $_COOKIE["cartId"];
}
else
{
// There is no cookie set. We will set the cookie
// and return the value of the users session ID

session_start();
setcookie("cartId", session_id(), time() + ((3600 * 24) * 30));
return session_id();
}
}

?>

[noparse]

tags really help out when you're posting code.[/noparse]

bpat1434

possibly... why not show us the contents of db.php?

supherman

thats the db.php

laserlight

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/furnitur/public_html/Templates/products.php on line 18

That warning is due to one or more of these:

Failed to connect to database server
Failed to select database
Failed to execute the corresponding SQL statement

The first two is possible in your code since you called ConnectToDb() without checking the return value. The third is possible if your database does not actually have a table named products with a column named itemName, e.g., you forgot to setup the database.

supherman

The databes is created and the coumn is correct. The error sais: Error: No database selected

supherman

<?php

// This page contains the connection routine for the
// database as well as getting the ID of the cart, etc

$dbServer = "localhost";
$dbUser = "furnitur_herman";
$dbPass = "usmcusmc";
$dbName = "furnitur_furnitur";

function ConnectToDb($dbServer, $dbUser, $dbPass, $dbName)
{
// Connect to the database and return
// true/false depending on whether or
// not a connection could be made.

$s = @mysql_connect($dbServer, $dbUser, $dbPass);
$d = @mysql_select_db($s,$dbName);
if(!$s || !$d)
return false;
else
return true;
}

function GetCartId()
{
// This function will generate an encrypted string and
// will set it as a cookie using set_cookie. This will
// also be used as the cookieId field in the cart table

if(isset($COOKIE["cartId"]))
{
return $COOKIE["cartId"];
}
else
{
// There is no cookie set. We will set the cookie
// and return the value of the users session ID

session_start();
setcookie("cartId", session_id(), time() + ((3600 24) 30));
return session_id();
}
}

this is the db.php

and this is the products.php:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<?php
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td width="30%" height="25">

<?php echo $row["itemName"]; ?>

</td>
<td width="10%" height="25">

R
<?php echo $row["itemPrice"]; ?>

</td>
<td width="50%" height="25">

<a href="cart.php?action=add_item&id=
<?php echo $row["itemId"]; ?>
&qty=1">Add Item</a>

</td>
</tr>
<?php } ?>
<tr>
<td width="100%" colspan="4">
<hr size="1"color="red" NOSHADE>

</td>
</tr>
<tr>
<td width="100%" colspan="4">

<a href="cart.php">Your Shopping Cart</a>

</td>
</tr>
</table>
</body>
</html>

Is the problem with the db or products page?

laserlight

The databes is created and the coumn is correct. The error sais: Error: No database selected

Check that the database name is correct.

supherman

it seems to be all correct

OK, I tried something. I changed the databse name to something ells that is incorrect. And it still gives the same error. so isnt it something ells thats causin the error: no database selected?

OK, neve mind my previous post...I changed the password and it did give me error. So it is not that!

It works!!!

Parse error: syntax error, unexpected T_VARIABLE, expecting '{' in /home/furnitur/public_html/Templates/cart.php on line 40

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<?php

include("db.php");

switch($_GET["action"])
{
case "add_item":
{
AddItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "update_item":
{
UpdateItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "remove_item":
{
RemoveItem($_GET["id"]);
ShowCart();
break;
}
default:
{
ShowCart();
}
}
function AddItem($itemId, $qty)
$result = mysql_query("select count(*) from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

$row = mysql_fetch_row($result);
$numRows = $row[0];

if($numRows == 0)
{
// This item doesn't exist in the users cart,
// we will add it with an insert query

@mysql_query("insert into cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
}
else
{
// This item already exists in the users cart,
// we will update it instead

UpdateItem($itemId, $qty);
}
function UpdateItem($itemId, $qty)
mysql_query("update cart set qty = $qty where cookieId = '" . GetCartId() . "' and itemId = $itemId");
function RemoveItem($itemId)

mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");
$result = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.cookieId = '" . GetCartId() . "' order by items.itemName asc");

Once the list of items is retrieved, each item is displayed as part of a table, as a table row:

while($row = mysql_fetch_array($result))
{
// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["itemPrice"]);
?>
<tr>
<td width="15%" height="25">
<font face="verdana" size="1" color="black">
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php

for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>
</font>
</td>
<td width="55%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
<td width="20%" height="25">
<font face="verdana" size="1" color="black">
$<?php echo number_format($row["itemPrice"], 2, ".", ","); ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=remove_item&id=<?php echo $row["itemId"]; ?>">Remove</a>
</font>
</td>
</tr>
<?php
}


// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["itemPrice"]);



$totalCost = $totalCost + ($row["qty"] * $row["itemPrice"]);


<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php
for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>



<script language="JavaScript">

function UpdateQty(item)
{
itemId = item.name;
newQty = item.options[item.selectedIndex].text;

document.location.href = 'cart.php?action=update_item&id='+itemId+'&qty='+newQty;
}

</script>


<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="70%" colspan="2">
<font face="verdana" size="1" color="black">
<a href="products.php">&lt;&lt; Keep Shopping</a>
</font>
</td>
<td width="30%" colspan="2">
<font face="verdana" size="2" color="black">
<b>Total: $<?php echo number_format($totalCost, 2, ".", ","); ?></b>
</font>
</td>
</tr>
</body>
</html>

bpat1434

There is an edit button, I suggest you use it.

Look at the function declaration on line 39... you're missing the opening "{"

supherman

<?php
}


// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["itemPrice"]);



$totalCost = $totalCost + ($row["qty"] * $row["itemPrice"]);


<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php
for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>

OK, line 117 states😛arse error: syntax error, unexpected T_STRING in /home/furnitur/public_html/Templates/cart.php on line 117

117 :

select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)"

bpat1434

You really should be able to get this one. Where does the PHP end, and the HTML begin?

supherman

thats fixed, no I have a new error : Parse error: syntax error, unexpected $end in /home/furnitur/public_html/Templates/cart.php on line 167 yust like the one I started with.
I am sory to bother like this, I realy am only starting this php stuff.

PLease help...I guese I am almost done

supherman

Parse error: syntax error, unexpected $end in /home/furnitur/public_html/Templates/cart.php on line 167:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<?php

include("db.php");

switch($_GET["action"])
{
case "add_item":
{
AddItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "update_item":
{
UpdateItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "remove_item":
{
RemoveItem($_GET["id"]);
ShowCart();
break;
}
default:
{
ShowCart();
}
}
function AddItem($itemId, $qty){
$result = mysql_query("select count(*) from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

$row = mysql_fetch_row($result);
$numRows = $row[0];

if($numRows == 0)
{
// This item doesn't exist in the users cart,
// we will add it with an insert query

@mysql_query("insert into cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
}
else
{
// This item already exists in the users cart,
// we will update it instead

UpdateItem($itemId, $qty);
}
function UpdateItem($itemId, $qty){
mysql_query("update cart set qty = $qty where cookieId = '" . GetCartId() . "' and itemId = $itemId");
function RemoveItem($itemId){

mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");
$result = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.cookieId = '" . GetCartId() . "' order by items.itemName asc");

while($row = mysql_fetch_array($result))
{
$totalCost += ($row["qty"] * $row["itemPrice"]);

?>
<tr>
<td width="15%" height="25">
<font face="verdana" size="1" color="black">
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php

for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>
</font>
</td>
<td width="55%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
<td width="20%" height="25">
<font face="verdana" size="1" color="black">
R<?php echo number_format($row["itemPrice"], 2, ".", ","); ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=remove_item&id=<?php echo $row["itemId"]; ?>">Remove</a>
</font>
</td>
</tr>
<?php



// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["itemPrice"]);



$totalCost = $totalCost + ($row["qty"] * $row["itemPrice"]);

?>
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php
for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>



<script language="JavaScript">

function UpdateQty(item)
{
itemId = item.name;
newQty = item.options[item.selectedIndex].text;

document.location.href = 'cart.php?action=update_item&id='+itemId+'&qty='+newQty;
}

</script>


<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="70%" colspan="2">
<font face="verdana" size="1" color="black">
<a href="products.php">&lt;&lt; Keep Shopping</a>
</font>
</td>
<td width="30%" colspan="2">
<font face="verdana" size="2" color="black">
<b>Total: $<?php echo number_format($totalCost, 2, ".", ","); ?></b>
</font>
</td>
</tr>
</body>
</html>

Please, somebody, I realy need help

laserlight

Indent your code properly, and you will be able to solve the problem yourself. For example, instead of:

for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}

Write:

for($i = 1; $i <= 20; $i++)
{
    echo "<option ";
    if($row["qty"] == $i)
    {
        echo " SELECTED ";
    }
    echo ">" . $i . "</option>";
}

supherman

<?php

include("db.php");

switch($_GET["action"])
{
case "add_item":
{
AddItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "update_item":
{
UpdateItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "remove_item":
{
RemoveItem($_GET["id"]);
ShowCart();
break;
}
default:
{
ShowCart();
}

function AddItem($itemId, $qty){
$result = mysql_query("select count(*) from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

$row = mysql_fetch_row($result);
$numRows = $row[0];

if($numRows == 0)
{
// This item doesn't exist in the users cart,
// we will add it with an insert query

@mysql_query("insert into cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
}
else
{
// This item already exists in the users cart,
// we will update it instead

UpdateItem($itemId, $qty);
}

function UpdateItem($itemId, $qty){
mysql_query("update cart set qty = $qty where cookieId = '" . GetCartId() . "' and itemId = $itemId");
function RemoveItem($itemId){

mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");
$result = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.cookieId = '" . GetCartId() . "' order by items.itemName asc");

while($row = mysql_fetch_array($result))
{
$totalCost += ($row["qty"] * $row["itemPrice"]);
}
?>

If i remove that part, then all goes on. So the problem is in there

supherman

Its still the same. Please look at the code above, I think it must be that. Because when its removed, it has no errors

supherman

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<?php

include("db.php");

switch($_GET["action"])
{
	case "add_item":
		{
		AddItem($_GET["id"], $_GET["qty"]);
		ShowCart();
		break;
		}	
	case "update_item":
		{
		UpdateItem($_GET["id"], $_GET["qty"]);
		ShowCart();
		break;
		}
	case "remove_item":
		{
		RemoveItem($_GET["id"]);
		ShowCart();
		break;
		}
	default:
		{
		ShowCart();
		}
}
function AddItem($itemId, $qty){
$result = mysql_query("select count(*) from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

$row = mysql_fetch_row($result);
$numRows = $row[0];

if($numRows == 0)
{
// This item doesn't exist in the users cart,
// we will add it with an insert query

@mysql_query("insert into cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
}
else
{
// This item already exists in the users cart,
// we will update it instead

UpdateItem($itemId, $qty);
}
}
function UpdateItem($itemId, $qty){
mysql_query("update cart set qty = $qty where cookieId = '" . GetCartId() . "' and itemId = $itemId");}
function RemoveItem($itemId){

mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");
$result = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.cookieId = '" . GetCartId() . "' order by items.itemName asc");

while($row = mysql_fetch_array($result))
{
$totalCost += ($row["qty"] * $row["itemPrice"]);
}
}
?>


<tr>
<td width="15%" height="25">
<font face="verdana" size="1" color="black">
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php

for($i = 1; $i <= 20; $i++)
{
    echo "<option ";
    if($row["qty"] == $i)
    {
        echo " SELECTED ";
    }
    echo ">" . $i . "</option>";
} 
?>
</select>
</font>
</td>
<td width="55%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
<td width="20%" height="25">
<font face="verdana" size="1" color="black">
R<?php echo number_format($row["itemPrice"], 2, ".", ","); ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=remove_item&id=<?php echo $row["itemId"]; ?>">Remove</a>
</font>
</td>
</tr>
<?php



// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["itemPrice"]);



$totalCost = $totalCost + ($row["qty"] * $row["itemPrice"]);

?>
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php
for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>



<script language="JavaScript">

function UpdateQty(item)
{
itemId = item.name;
newQty = item.options[item.selectedIndex].text;

document.location.href = 'cart.php?action=update_item&id='+itemId+'&qty='+newQty;


</script>


<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="70%" colspan="2">
<font face="verdana" size="1" color="black">
<a href="products.php">&lt;&lt; Keep Shopping</a>
</font>
</td>
<td width="30%" colspan="2">
<font face="verdana" size="2" color="black">
<b>Total: $<?php echo number_format($totalCost, 2, ".", ","); ?></b>
</font>
</td>
</tr>
</body>
</html>

OK, I got the parsing correct and I figured out what whent wrong. Then this came up...

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/furnitur/public_html/Templates/cart.php:10) in /home/furnitur/public_html/Templates/db.php on line 40

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/furnitur/public_html/Templates/cart.php:10) in /home/furnitur/public_html/Templates/db.php on line 40

Warning: Cannot modify header information - headers already sent by (output started at /home/furnitur/public_html/Templates/cart.php:10) in /home/furnitur/public_html/Templates/db.php on line 41

Warning: mysql_query() [function.mysql-query]: Access denied for user 'furnitur'@'localhost' (using password: NO) in /home/furnitur/public_html/Templates/cart.php on line 40

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/furnitur/public_html/Templates/cart.php on line 40

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/furnitur/public_html/Templates/cart.php on line 42

Fatal error: Unknown function: showcart() in /home/furnitur/public_html/Templates/cart.php on line 19

supherman

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<?php

include("db.php");

switch($_GET["action"])
{
case "add_item":
{
AddItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "update_item":
{
UpdateItem($_GET["id"], $_GET["qty"]);
ShowCart();
break;
}
case "remove_item":
{
RemoveItem($_GET["id"]);
ShowCart();
break;
}
default:
{
ShowCart();
}
}
function AddItem($itemId, $qty){
$result = mysql_query("select count(*) from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");

$row = mysql_fetch_row($result);
$numRows = $row[0];

if($numRows == 0)
{
// This item doesn't exist in the users cart,
// we will add it with an insert query

@mysql_query("insert into cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
}
else
{
// This item already exists in the users cart,
// we will update it instead

UpdateItem($itemId, $qty);
}
}
function UpdateItem($itemId, $qty){
mysql_query("update cart set qty = $qty where cookieId = '" . GetCartId() . "' and itemId = $itemId");}
function RemoveItem($itemId){

mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and itemId = $itemId");
$result = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.cookieId = '" . GetCartId() . "' order by items.itemName asc");

while($row = mysql_fetch_array($result))
{
$totalCost += ($row["qty"] * $row["itemPrice"]);
}
}
?>


<tr>
<td width="15%" height="25">
<font face="verdana" size="1" color="black">
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php

for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>
</font>
</td>
<td width="55%" height="25">
<font face="verdana" size="1" color="black">
<?php echo $row["itemName"]; ?>
</font>
</td>
<td width="20%" height="25">
<font face="verdana" size="1" color="black">
R<?php echo number_format($row["itemPrice"], 2, ".", ","); ?>
</font>
</td>
<td width="10%" height="25">
<font face="verdana" size="1" color="black">
<a href="cart.php?action=remove_item&id=<?php echo $row["itemId"]; ?>">Remove</a>
</font>
</td>
</tr>
<?php



// Increment the total cost of all items
$totalCost += ($row["qty"] * $row["itemPrice"]);



$totalCost = $totalCost + ($row["qty"] * $row["itemPrice"]);

?>
<select name="<?php echo $row["itemId"]; ?>" onChange="UpdateQty(this)">
<?php
for($i = 1; $i <= 20; $i++)
{
echo "<option ";
if($row["qty"] == $i)
{
echo " SELECTED ";
}
echo ">" . $i . "</option>";
}
?>
</select>



<script language="JavaScript">

function UpdateQty(item)
{
itemId = item.name;
newQty = item.options[item.selectedIndex].text;

document.location.href = 'cart.php?action=update_item&id='+itemId+'&qty='+newQty;


</script>


<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<tr>
<td width="70%" colspan="2">
<font face="verdana" size="1" color="black">
<a href="products.php">&lt;&lt; Keep Shopping</a>
</font>
</td>
<td width="30%" colspan="2">
<font face="verdana" size="2" color="black">
<b>Total: $<?php echo number_format($totalCost, 2, ".", ","); ?></b>
</font>
</td>
</tr>
</body>
</html>