Mysql and Arrays

james_ecker

I am some what new to php or at least to programing, so I need some guidence. I am querying a database with several fields and transfering the information to and array. I am transfering the information to an array, so I can display like this:

Product A vendor A vendor B vendor C vendor D
model A price A price B price C price D
model B price A price B price C price D
etc

Product B vendor A vendor B vendor C vendor D
model A price A price B price C price D
model B price A price B price C price D

My problem is I have too many vendors across the screen and I would like to display the information like:

Product A vendor A vendor B vendor C vendor D
model A price A price B price C price D
model B price A price B price C price D

Product A vendor E vendor F vendor G vendor H
model A price E price F price G price H
model B price E price F price G price H

etc...

Here is how I fill my array and what my CURRENT array looks like:

<?php do {

$dtlCost[$row_costs['product']][$row_costs['model']][$row_costs['vendor']]]=$row_costs['price'];

} while ($row_costs = mysql_fetch_assoc($costs)); ?>

I figure I need nested do/while loops with vendor as my inter most do/while. I need to be able to change the model then scroll through the vendors and display their prices. Once all of the models have been displayed change the product, and repeat the scrolling through the models and vendors again.

Are there any suggestions? or Pointing in the right direction?

Thanks in advance,

James

TobyRT

Best thing I can suggest is to incorporate it into a table along these lines:

Connect the database and perform your SELECT query
Start the table before you start your 'while' loop and establish the column headings, eg
<html>
<table>
<tr>
<td>Model</td><td>Price1</td><td>Price2</td></tr>

//Then start your while loop and end for each result echo it in the table
echo '<tr><td>'.$row['model1'].'</td><td>'.$row['price1'].'</td><td>'.$row['price2'].'</td></tr>';

Then after you've echoed all the results (i.e. AFTER the while loop) just echo a '</table>'

That's loosely how I do it at least.

james_ecker

THank you I do have the out put going to a table. I just am not sure how to step through array. The values of the array are based on user input. can you explain how to step through the array?

$dtlCost[$row_costs['idsubgroup']][$row_costs['idsize']][$row_costs['idshipper']]=$row_costs['pur_cost'];

I want to step to the first item in idsubgroup
then step through all of the idsize for that idsubgroup

then step to the second item in idsubgroup
then step through all of the idsize for that idsubgroup

so on..

Thanks again for you help...

TobyRT

Eek.

That's a bit beyond me to be honest - i'm still pretty much a newb meself!