<?

$db = mysql_connect("localhost", "username", "password") or die("Could not connect.");

if(!$db) 

	die("no db");

if(!mysql_select_db("database name",$db))

 	die("No database selected.");

$acckey="yourkey"; //your aws access key goes here

?>

<?php

include "connect.php";

$getitems="SELECT itemid,ibsn from amz";

$getitems2=mysql_query($getitems) or die("Could not get items");

while($getitems3=mysql_fetch_array($getitems2))

{

  $url="http://webservices.amazon.com/onca/xml?Service=AWSECommerceService&AWSAccessKeyId=$acckey&Operation=ItemLookup&ItemId=$getitems3[ibsn]&ResponseGroup=Medium,Offers&Condition=All&MerchantID=Amazon";

  $var=file_get_contents($url);

  $pricing=explode("$",$var);

  $lastindex=sizeof($pricing)-1;

  $newprice=$pricing[$lastindex];

  $theprice=explode(".",$newprice);

  $deci=substr($theprice[1],0,2);

  $realprice="$theprice[0].$deci";

  print "$realprice<br>";

  $updatecron="Update amz set price='$realprice' where itemid='$getitems3[itemid]'";

  mysql_query($updatecron) or die("Could not update cron");

  mysql_query("Delete from bgook");

  

  



}

?>