Echo Array Data

mainstreetop · March 3, 2010, 1:58am

I’m new to all of this and am not sure how to retrieve certain data. Here’s my query…


$sql = 'SELECT item.*, attributes.*
          FROM item
          LEFT JOIN attributes
          ON item.ProductNumber = attributes.ProductNumber
          WHERE item.ProductNumber = 9503731
          ORDER BY attributes.AttributePriority';
$result = mysql_query($sql);
while ($row = mysql_fetch_array($results))  {
   $ProductNumber = $row['ProductNumber'];
   $Image = $row['ItemImage'];
   $AttribPriority =  $row['AttributePriority'];
   $AttribName = $row['AttributeName'];
   $AttribValue =  row['AttributeValue'];
   $Att_array = array($AttPriority, $AttName, $AttValue);
}

This is the information I am having trouble rendering properly. It is my ATTRIBUTES table. Every product in the ITEMS table has the potential for up to 20 attributes where I would like to display both the AttributeName & AttributeValue. I am trying to echo each attrib name & value.

This is how the data is stored in the ‘attribute’ table:

ProductNumber AttributePriority AttributeName AttributeValue
9503731 4 Clerk Totalizers [Nom] 4
9503731 5 Compartments 4 Bill Drawer
9503731 5 Compartments 5 Coin Drawer

It was previously suggested that I set up my code like this:


$getAll_array  = array();
while ($row = mysql_fetch_array($results))  {
   array_push($getAll_array, $row);
}

If I print_r($getAll); I see all the data within the array. I’m just not sure how to retrieve the rows individually so I can place the variable in HTML for display. I apologize in advance if I’m not being 100% clear.

Thanks for any help.

Mittineague · March 3, 2010, 4:18am

Hi mainstreetop, welcome to the forums,

Your first bit of code will assign the values of whatever the last $row is to the variables inside the while{} as each pass will overwrite the older assigned values.

Probably not what you want it to do.

Putting them into an array is a good idea. Using print_r (or var_dump) will show you what that array looks like. i.e. the $key -> $values

Once you know this information it’s easier to figure out how to get at the parts you’re interested in. What does that (at least a small portion of it) look like?

mjpr · March 3, 2010, 12:58pm

To retieve each element of the array?


foreach($getAll as $key=>$val)
{
echo $key . '->'. $val;
}

mainstreetop · March 3, 2010, 2:05pm

Mittineague & mjpr

Thank you both for taking the time to respond.

@ Mittineague…
Your explanation helped me realize that I only needed to put the ‘attributes’ fields within the while(). So, this has been solved - thank you.

@ Mittineague & mjpr…
What I still do not understand is how to selectively retrieve array data. If I were to place the $results in an array …

$all_array = array();
  $result = mysql_query($query)  or die(mysql_error());
  while ($row = mysql_fetch_array($result)) {
   array_push($all_array,$row);
  }

I get what’s below. There is a lot more, but I cut it off for the sake of of space…

I do not understand how to pick & choose what I want out of this array. Also, because it’s in a while statement, it looks like each row is being called again for every attribute. Hopefully, that made sense???

Mittineague · March 3, 2010, 5:52pm

The print_r shows that $all_array is an array and that each member contains an array of numerical and associative key value pairs (152 of them!).

[0] => Array ( 
	[0] => 764 
	[RecordID] => 764 
	[1] => 5099858 
	[ProductNumber] => 5099858 
	[2] => ALE 
	[Prefix] => ALE 
	[3] => 36650 
	[StockNumber] => 36650 
	[4] => ALERA 
	[MFRName] => ALERA 
	[5] => 36 
	[MFRId] => 36 
	[6] => 201 
	[BrandId] => 201 
	[7] => 40799 
	[SkuGroupId] => 40799 
	[8] => 63 
	[ProductClassId] => 63 
	[9] => L 
	[AssemblyCode] => L 
	[10] => N 
	[RecycleInd] => N 
.......
	)
[1] => Array ( 
	[0] => 764 
	[RecordID] => 764 
	[1] => 5099858 
	[ProductNumber] => 5099858 
	[2] => ALE 
	[Prefix] => ALE 
	[3] => 36650 
	[StockNumber] => 36650 
	[4] => ALERA 
	[MFRName] => ALERA 
	[5] => 36 
	[MFRId] => 36 
	[6] => 201 
	[BrandId] => 201 
	[7] => 40799 
	[SkuGroupId] => 40799 
	[8] => 63 
	[ProductClassId] => 63 
	[9] => L 
	[AssemblyCode] => L 
	[10] => N 
	[RecycleInd] => N 
.......

So

echo $all_array[0][0];
// outputs 764
echo $all_array[0]['RecordID'];
// outputs 764
foreach ($all_array as $row_array )
{
	echo $row_array['RecordID'] . "<br />\
";
}
// outputs 764<br />
// 764<br />
// .....

mainstreetop · March 3, 2010, 11:59pm

Thank you Mittineague for explaining it further. It is starting to make sense. I really appreciate you following my thread. My background is peddling these products - not building a site (obviously). With a little more practice, though, maybe I’ll get this thing where I think it should be.

Thanks again.

Mittineague · March 4, 2010, 2:55am

Glad to help. Working with arrays, especially multi-dimensional arrays, can be a bit overwhelming at first. But it gets easier.

Topic		Replies	Views
mysql_fetch_array and variables PHP	1	681	October 23, 2010
Array issue PHP	4	392	March 9, 2010
Echo mysqli result items PHP	6	4642	January 18, 2018
Beginner level processing and echoing arrays PHP	2	338	March 4, 2011
Storing retrieved data into a variable PHP	6	1263	January 13, 2010

Echo Array Data

Related topics