Problem with variable declaration in switch statement

Posted on 16th Feb 2014 07:03 pm by admin

Hello, I am having some trouble assigning a value to a variable inside a switch statement. What I am trying to do here is trip an error if the user has already added an item in the shopping cart. The While and Foreach loops work perfectly fine. The problem is that the value of variable $error does not get passed outside of the case. As a result, I cannot get the error message to display. I really need to get this to work and any help is appreciated. The code looks something like this:

Code: switch ($action) {
case 'add' :
{
if ($_SESSION['CartID'] == "")
{

$query = 'INSERT INTO ShopCart( UserID )VALUES("' . $UserID . '")';
mysql_query($query, $db) or die(mysql_error($db));

$Shop = 'SELECT ShopCartID FROM ShopCart WHERE UserID = "' . $UserID . '" ORDER BY ShopCartID ASC LIMIT 1';
$Cart = mysql_query($Shop);
$ShopCart = mysql_fetch_row($Cart);
$_SESSION['CartID'] = $ShopCart[0];
}
$query = 'SELECT ProductID FROM ShopCartLine WHERE ShopCartID = "' . $_SESSION['CartID'] . '"';
$result=mysql_query($query, $db) or die(mysql_error($db));

//$row = mysql_fetch_row( $result );
while($var = mysql_fetch_array($result))
{
foreach ($var as $i) {
if ($i == $ProductID) {
$error = 1; //TRIP THE ERROR HERE!
echo "<script type='text/javascript'>window.top.location='http://amarcy2.db-class.ids.uic.edu/shopcart.php';</script>";
}
}
}
}


The code being used to display the error message is as follows:

Code:
if ($error == 1) {
echo '<p>You already have this item in your basket!</p>';
}

Your Answer:

Login to answer

Other forums

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

Warehouse Management
Hi,

On our system, we have two storage locations ( A and B ) where A is the main factory

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

want a code for uploading and downloading
i m trying to upload and download to my site..i need upload and download code ...i use a code for up

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi