0

Hi,

I am trying to display results from a MySQL database, in a block.

Basically, I am trying to achieve:
- all the same brand to display in line with each other.
- Then this to be repeated for as however many brands their are.
However,
Each brand has X products, all these products need to be displayed under the brand heading.
I have tried to do it, however I am getting this error and am really stumped on what to do, or even if I have done this right.
Code below...

$sql = 'SELECT * FROM brand';
	$setBrand=array();
	foreach ($conn->query($sql) as $row) {   
		$setBrand[]=<<<END
<div class="brandRowM">
    <div class="brandRow">
        <div class="brand"><a href="#">$row[brand]</a></div><br />
        <div class="productSmPic">
            	<ul>
END;
	$sql = 'SELECT * FROM products WHERE brand = '.$row['brand'].'';
			foreach ($conn->query($sql) as $info) {   
			$setInfo[]=<<<END
					<li><a href="product.php"><img src="$info[PFN1]" width="100px" height="60px" /></a>
						<ul>
							<li><div class="productSmName">$info[name]</div></li>
							<li><div class="productSmCode">$info[coda]</div></li>
							<li><div class="productSmRRP">RRP: $$info[cost]</div></li>
							<li><div class="productSmQRP">Click to see price</div></li>
						</ul>
					</li>
END;
	}
	$setInfo=implode("\r\n",$setInfo);

<<<END
             	</ul>    
        </div>        
    </div>
</div>
END;
	}
	$setBrand=implode("\r\n",$setBrand);

Im not sure if I need to group this together somehow, or????


If anyone can help, I would really appreciate it.

Cheers,

QWaz

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by cwarn23
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.