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

how to populate a drop down box
Hi buddies!

PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLO

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

ctype() validation - allowing illegal characters
Hello,
I use ctype() to filter and validate a user form. However, I am trying to allow certain c

preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the strin

Populate drop down list from table??
Lets say for arguments sake that i have a table which contains the numbers 1 to 10.
How can i get

When i am Canseling the Billing Document in VF11 I am getting Shortdump
Hi Experts

When i am Canseling the Billing Document in VF11 I am getting Shortdump.