We have the following query, which selects all items under £1 with free postage, buy it now and ending in more than 1 hour:
"[url removed, login to view]"+q+r+s+t+u+v+w+x+y+z&_in_kw=2&_ex_kw=&_sacat=See-All-Categories&"+_okw=a+b+c+d+e+f+g+h+i+j+k+l+m+n+o+p+q+r+s+t+u+v+w+x+y+z&_oexkw="+&_mPrRngCbx=1&_udlo=0&_udhi=1&LH_BIN=1&LH_IncludeSIF=1&_LH_Time="+1&_ftrt=902&_ftrv=1&_sabdlo=&_sabdhi=&_samilow=&_samihi=&LH_FS=1"+&_sadis=200&_fpos=Zip+code&_fsct=&LH_SALE_CURRENCY=0&_fss=1&_sas"+lop=1&_sasl=&fsradio=%26LH_TopRatedSellers%3D1&_sop=1&_dmd=1&_ip"+g=200"
We want a PHP script that uses this criteria to grab these results and put them straight into a table in MYSQL.
We already have database all set up, with the columns: ID, EbayItemID, Description, SellerID, Price etc.
Once the items are in the table, we need a VERY basic page to show them all. We need to be able to delete items from here. Also, an "delete all that contain" field/button which loops through and deletes anything in the DB with a particular phrase.
This should take an hour or two for somebody who's used the ebay API before and there will be more work available to the successful bidder. Thanks!