Sending basket to SagePay

[petenaylor]

Hi all

I am writing a script to send the contents of my SQL table to SagePay as a string $basket. I have got it to work OK with adding one item in. My code is this:

 

$query_basket = mysql_query("SELECT * FROM `store_basket` WHERE sessionid='".$sessionid."'");

        $rows = mysql_num_rows($query_basket);

$allitems = count($rows);

        while($result_basket = mysql_fetch_array($query_basket)) {

        $price_without_tax = $result_basket['price'];

        $tax = 17.5;

        $price_with_tax = $result_basket['price'] + $tax;

        $price_times_qty = $result_basket['price'] * $result_basket['qty'];

$basket_item = $result_basket['item'];

$basket_qty = $result_basket['qty'];

}

 

if($allitems == 1) {

$basket .= "1".":".$basket_item.":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;

} else {

$basket .= $allitems.":".$basket_item.":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;

}

 

$rows++;

 

However, it only shows one item in the basket when there is more than one in my table.

 

I need to do a loop so that each item in the table is outputted in the $basket string.

 

Thanks

Pete