Thanks for the suggestions.
Mittineague> I had tried close previously, I must have been trying reset as an alternative?
Catweasel> Thanks, your code did not quite work for me, but it pushed me in the right direction. I could not get the items to add to the DB at all until I moved the binding inside the loop
foreach ($xml->SearchResultItemArray->SearchResultItem as $searchitem)
$itemID = $searchitem->Item->ItemID;
$title = $searchitem->Item->Title;
$link = $searchitem->Item->ListingDetails->ViewItemURL;
$current_price = $searchitem->Item->SellingStatus->CurrentPrice;
$bid_count = $searchitem->Item->SellingStatus->BidCount;
$stmt->bind_param('issdi', $itemID, $title, $link, $current_price, $bid_count)
Now it is adding all the details ok, assume I am losing some efficiency though?