hal-11

Hi I am currenly doing a project where i am required to send some values to secure http via post request..I am using Curl for this and that works fine, what I am stuck on is how to retrieve stored database values and send each one individually in a loop to the specified url in the curl script. Hard to explain but heres an example: e.g I have a number of reports in db (123456, 123654, 456321) and each one will retrieve a report from the url as they are the specified report_ids required. I would like to pull each one from the database using a foreach loop assigning the report number to $reportid variable one at a time, and also when the report is retrieved with each one, fwrite it to file. I can currently get all of the above working but only if i assign the report number in the script rather than assigning it the db value and looping through each one. I suppose my question is how can i not only loop through db values but assign each id to the reportid sent via curl and then do it all over again for the next id... Any help in the right direction would be awesome.!

Yes it would actually be in batches of around 10 - 20 thousand products, so it prob wouldnt work. I will have a formulae sorted for the euro easily its just trying to implement the two at the same time. I was thinking of creating another variable say $price1 - insert euro formulae then call this the 'euro-price' header, but without much success i must admit. Brick wall meet my face

Hi, Actually the price is determined by a formulae that calculates the product price and then adds how much profit margin to be added on. the currency rate always stays the same in the formulae. So basically my output file creates all the correct prices in gbp, but in that same file I also require the output to produce a price for euro. i.e if($retailerId == 1) calculate formulae and produce price gbp. not sure how to implement it for two seperate formulaes with same retailerId but with different results(euro). Hope that helps...

Hi, this is my first post on the forum. I am having a bit of trouble trying to create a file with the price of a product in two different currencies. For example my $price will be calculated through a number of discounts and produce the correct price for the product in the output file, but i am now required to produce the outputted price in gbp and eur. Any help would be very much appreciated.