loop issue with basket

[petenaylor]

Hi all. How do I loop the below script?

 

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

        $rows = mysql_num_rows($query_basket);

      $r = mysql_fetch_array($query_basket);

      $allitems = $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'];

      $basket_initial1 = $result_basket['initial1'];

      $basket_initial2 = $result_basket['initial2'];

      $basket_initial3 = $result_basket['initial3'];

 

}

 

if($allitems == 1) {

$basket .= $allitems.":".$basket_item."  ".strtoupper($basket_initial1)."-".strtoupper($basket_initial2)."-".strtoupper($basket_initial3).":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;

} else {

$allitems = $rows;

 

$basket .= ":".$basket_item."  ".strtoupper($basket_initial1)."-".strtoupper($basket_initial2)."-".strtoupper($basket_initial3).":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;

 

    }

 

Basically if there is more than one row I need to loop the $basket string so that it shows the values for each item.

 

Thanks

Pete