Loop? foreach or do?

[vinny199]

Hello,

i have the following problem:

My shopping cart stores the Quantity ought value of each item as

$HTTP_SESSION_VARS["ticteting"]->col("Quantity"); 

$row_rsadverts['ad5'] is the quantity still in stock for the item concerned

I need to make a value: $my_value_check a substraction between a recordset value $row_rsadverts['ad5'] minus $HTTP_SESSION_VARS["ticteting"]->col("Quantity");

This will check as the shopper goes to the payment card processor that the items he has in his cart have not sold out while he was shopping.

so, if $my_value_check is inferior or equal 0 for each item in the cart, the shopper should be redirected to a page called no_tickets.php.

If those items are still in stock, he should be redirected to cart_05.php

My system as described works.

Only there is one glitch...

it only checks the first row retireved of the recordset, instead of al the rows matching the query.

Therefore my suystems checks the first item in the carts availaility and redirect accordingly instead of checkin EACH item in the cart's availability and THEN redirect if one of them has become out of sotck

Recordset: (this is not where the problem is)

$my_value = $HTTP_SESSION_VARS["ticteting"]->col("ItemID");
mysql_select_db($database_to_octo, $to_octo);
$query_rsadverts = "SELECT * FROM adverts  WHERE adverts.AID = $my_value";
$rsadverts = mysql_query($query_rsadverts, $to_octo) or die(mysql_error());
$row_rsadverts = mysql_fetch_assoc($rsadverts);
$totalRows_rsadverts = mysql_num_rows($rsadverts);

This is where the problem is.

The recordset retrieves the right row but only one of them, whereas it should check for each of the items in the cart before redirecting

$my_value_check = $row_rsadverts['ad5'] - $HTTP_SESSION_VARS["ticteting"]->col("Quantity"); 
if ($my_value_check <= 0) {
	header("Location: no_tickets.php");
}
else
{
	header("Location: cart_05.php");

I hope i am explaining things ok..

Many thanks,

Vinny

[leatherback]

Actually..
The problem is where you say it is not, AND where you say it is..

First: you only retrieve one row from your database:

$row_rsadverts = mysql_fetch_assoc($rsadverts);

You want to do something like:

// Create a variable $LIST which holds a comma separated list of selected items, e.g.:
$LIST = implode(',', $_SESSION['cart']);

// Select all rows in the database that hold ID in LIST, and count the number of rows per AID:
$query = "SELECT AID, count(*) as counted FROM adverts  WHERE adverts.AID in ($LIST) group by AID";

// Select the data
$rsadverts = mysql_query($query) or die(mysql_error().$query);

// now retrieve the data:
$counts = array();
while($row = mysql_fetch_assoc($rsadverts))
  {
  $counts[$row['AID']] = $row['counted'];
  }

Now you have an array with the counts for each product.

I am not sure how you have your session() organized, but: HTTP_SESSION_VARS is depreciated. Use $SESSION[]. I presume you have $SESSION['ticteting']['quantity'] in your session, but I am not sure. Please explain the structure of your session (e.g., post the output of print_r($_SESSION); and we can see how to help you get this show on the road.

J.