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

Other php-forum

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY

Cant display mysql data
Hey all,

I am learning php and my first goal is to create a simple CMS. At the moment I am st

How to display value in drop down list after form has been reloaded
Please bear with me as I am very new to php and html.

I have a form with several drop down me

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

Need help in log in and log out?
hi there all of u. i have recently created a site for someone. i have placed log in and log out and

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

Multidimensional array problems in $_POST
I'm having trouble with a three-dimensional $_POST array. It starts as a two-dimensional array on th

Help with Hyperlink
Hi,

What I am trying to do may be simple, I just can't get it to work. Ok...

I am usin