array & querys help/advice.

Posted on 16th Feb 2014 07:03 pm 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

Your Answer:

Login to answer

Other forums

Best PHP Documentation generator
Hello guys!

I would like to hear from you what is the best PHP documentation generator. Perso

Printing a webpage
I use this to print the webpage: o

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

Can't seem to capture a variable in a chained select
I'm *this* close to having a chained select running but for some reason it doesn't seem to be pickin

Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h