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

Securing a user input - need some confirmation
Hello All,

I am in the process of recoding a large proportion of an e-commerce site, one of t

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

Mail sending is slow on server
Why mail is taking time to be send on apache-linux server

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php


So the documentation states tha

Cursor statement failed with errors
Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

How to assign JS screen.width to ASP.Net variable
I've got this ASP.net routine that gets the cookie value of the screen width, but now I need to chan

Prevention Help
How can I use PHP or any other language (feel free to move this thread) to prevent users doing scree

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown