Inserting database values into an array.

[dkin]

I have my item database almost complete, but there are a few things I must tweak.

This is what I need.

I have many attributes for each item

AC
AR
PR
FR
Hp
Pow
etc
etc

I am wanting to display only the attributes which have values and I beleive an array would be the easiest way to do this.

So my first question.

Can I put mysql database values into an array?

I tried and it did not work. I used this as my value

$row["AC"];

If someone could correctly insert this into an array and show me I would be very thankful.

Second is how would I go about only showing the attribute name if there is a value in it?

[coopster]

OK. Now look closer at the loop construct to see how it is working. We will move the table columns outside of the loop that builds each column of your database table and add a couple of html non-breaking spaces (we'll also put your key back in)...

while ($row = mysql_fetch_array($result)) { 
 print '<tr>'; 
 print '<td>'; 
 foreach ( $row as $key => $val ) { 
 if (!empty($val) && $key!= "Item_Name" ) { 
 print $key . " : " . $val . '&nbsp;&nbsp;'; 
 } 
 } 
 print '</td>'; 
 print '</tr>'; 
}

[edited by: coopster at 6:20 pm (utc) on June 23, 2004]

[dkin]

now how would I get the name of the attribute infront of the value?

[coopster]

I updated the previous message while you were posting. You just have to add the key back in...

[dkin]

For some reason my form will not successfully submit to my db when I have fields named Range and Int.

Anyone know why?

[coopster]

They are reserved words.

[dev.mysql.com...]

[dkin]

I figured as much.

Thx it works again.

[dkin]

Now when I enter that code into my main page it only shows one item from my db.

But it takes the values specified from all items and inputs it into each td.

I only want the attributes which match the item name or id to be displayed in the same <tr>

[dkin]

anyone know?

[coopster]

You'll have to incorporate some more logic, particularly some control structures [php.net] to compare [php.net] data and determine whether or not you want to display them.