Help with Array

[Jamez]

The code below querys mysql and spits the results out in 3 rows using tables. However It only echo's one field from the row in the DB....

i want to echo $row["name"], $row["price"] and $row["desc"], how can i add these additional vars to it?? 😕

include 'admin/connect.php';
	mysql_select_db("dogg_products");
	$sql = "SELECT * FROM prods WHERE cat = '$category' AND subcat = '$subcategory'";
	$result=mysql_query($sql);
	if (!$result) 
		{
    	print mysql_error()." ERROR - browse query failed.";
		}
	while ($row = mysql_fetch_assoc($result)) 
		{
		$array = $row['name'];
		} 
	$chunks = array_chunk($array, ceil(count($array) / 3)); 

echo ' 
Total: <b>' . mysql_num_rows($result) . '</b><br><br> 
<table border="0" cellpadding="5"> 
<tr valign="top"> 
'; 

foreach ($chunks as $value) 
	{  
	echo '<td><table border="0" cellpadding="5">'; 
	foreach ($value as $title) 
		{ 
    	if (!$title) 
			{
			$title = '&nbsp;';
			} 
    	echo '<tr><td><a href="">'.$title.'</td></tr>'; 
		} 
	echo '</table></td>'; 
	} 
echo '</tr></table>';
}

[Weedpacket]

You missed making $array an array:

Originally posted by Jamez

while ($row = mysql_fetch_assoc($result)) 
        {
        $array = $row['name'];
        }  

[/b]

while ($row = mysql_fetch_assoc($result)) 
        {
        $array[] = $row['name'];
        }  

If you want all those variables in there, why take them out of the $row array?

while ($row = mysql_fetch_assoc($result)) 
        {
        $array[] = $row;
        }  

And of course, if you only want those fields, then you should only ask for those fields in the first place:

    $sql = "SELECT name,price,desc FROM prods WHERE cat = '$category' AND subcat = '$subcategory'"; 

[Jamez]

Now that $array is an "$array[]" and $row[name] is just "$row" how do i get all the vars in it to be echo'd in the foreach ??

[Weedpacket]

Start by having a look at the contents of the array with print_r(). Judging from your code you should be able to work out how to access whichever bits you want once you see how they're being stored in the array.