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 {
Did you know?Explore Trending and Topic pages for more stories like this.


// 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
No comments posted yet

Your Answer:

Login to answer
209 Like 10 Dislike
Previous forums Next forums
Other forums

Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

Procedural to OOP
ohn Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pri

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

Multiple PHP errors when clicking a link..and..removing a ghost..
Hi - I have 2 problems with a new website - homeswapvacations.com, which I need help solving.

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash