array & querys help/advice.

Posted on 16th Feb 2014 by admin

Ok so here goes , I have a mysql database and basically here's what I need to do.

// foreach store id
// foreach product id {


// query with where store id and product id

// get price row for each products, add them all together

// close foreach store & product id {{

// find the lowest price along with what store id has the lowest price and echo it.


How would I go about doing this? I have tried so many ways but i just cant seem to do it.

Much appreciated,

Many thanks

Other forums