close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

getting info from and presenting my array content

Thread began 5/06/2011 9:17 am by CraigR | Last modified 5/06/2011 10:31 am by CraigR | 1096 views | 4 replies |

CraigRBeta Tester

getting info from and presenting my array content

My client sells machine parts, each type having a different set of specifications.

I wish to display the item specs for each item on the item detail page

I have set my sql select statement to load all of the fields from the spec table, (the table queried depends on the item type).

This returns all of the specs for the product I need, returning a single row.

As each spec table has a different number of fields, I thought the best approach would be to store the recordset row in an array, with the field names as the keys, and the data as values.

This means I can have one page for my item detail, regardless of the item type.

So far so good.


I can do a print_r on the array and see my data, what I cannot do is loop through the array and show the values in a tabular form

Attached Files
item_detail_vanilla.zip
Sign in to reply to this post

Jason ByrnesWebAssist

this code looks correct to me:

php:
<?php 

    
foreach ($specificationsarray as $header => $value) {
        echo 
"Header: $header; Value: $value<br />\n";
    } 
?>



What exactly is the problem you are having getting the array to show the values in a tabular form?

what is the result of the <?php print_r($specificationsarray); ?> code? This will give me some idea of the data you are working with.

Your foreach loop[ looks like it should do what you are asking about, so I guess I need clarification on what you are expecting from the foreach loop that it is not giving.

Sign in to reply to this post

CraigRBeta Tester

the result of print_r is as follows, (for example, product id number 2)

Array ( [2] => Array ( [AnchorID] => 2 [ItemID] => 2 [StockNumber] => CSA-60 [ThreadClass2A] => 8-32 [APM015] => .875 [BPM03] => .700 [CPM01] => .080 [DPM01] => .095 [EPM005] => .070 [FPM01] => .16 [GPM01] => .07 [Material] => Steel ) )

I think the problem may be that the array is multidimensional ?? , but this was the closest i got after a few tries.

Sign in to reply to this post

Jason ByrnesWebAssist

OK, I see.


a recordset is already an array. you dont need to convert it by using a loop.

change:

php:
do {

  $specificationsarray[$row_rsspecifications['ItemID']] = $row_rsspecifications;
} while ($row_rsspecifications = mysql_fetch_assoc($rsspecifications));


to:

php:
$specificationsarray = $row_rsspecifications;
Sign in to reply to this post

CraigRBeta Tester

Thats it!

I'm overcomplicating things as usual.

Cheers

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...