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

Pre-Fill out a PHP form...??
This is for work actually (geek squad). We have to fill out this online php form at work over and ov

Scene graph using Direct3D?
There are several C++ scene graph based packages available for OpenGl, like say OSG,

http://w

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

Tracking Unique Clicks
Hi guys and gals,

Basically I have a database which tracks clicks on my outbound links, I do

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec

user data not transferring to new page
I'm a PHP learner. After an index.php page, the user goes to a login.php page. Both pages seem to

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

Error when call dll from oracle
Hi all, please help me!

I have dll write C language, I want call it from oracle procedur

Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data