A
Anonymous
Guest
Two ways of doing this. One is when you're printing a row for the products, you can perform a second query to display the additive. However, this is very inefficient as it requires many queries to be performed.
The easiest way is to use table joins to get all the data out in one go. I can't advise you 'cos I don't know the setup of your db or what you're trying to access.
If you've already explored this option and joins can't be created, then I'd advise running 2 queries first if that's possible. And then create an array based on the results and output the Array.
The easiest way is to use table joins to get all the data out in one go. I can't advise you 'cos I don't know the setup of your db or what you're trying to access.
If you've already explored this option and joins can't be created, then I'd advise running 2 queries first if that's possible. And then create an array based on the results and output the Array.