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

help connecting a form to php and then emailing the form
Ok. So, I made a form, and I need help to where when submitted, I get an email with the submitted de

Please help with SMTP Authenticated PHP Email Form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

user validation always displaying invalid ? please help
Hello,

I have 2 accounts and there is a field in mysql called validated it can be either &quo

parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

rename the file
File.txt

Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s