display problem

Bluelove

Hi, i have a db with two tables, one with products and one with the labels to put on the products, the label table contains the product_id and nr (wich is the nr of labels to print for this item)

after querying i wnat to echo the results in a table of 3 coloms, but i can't get it to work 🙁
normal fetching all data goes like this

while($row = mysql_fetch_array($result)) {
	for ($i = 1; $i <= $row[nr]; $i++) { 
    	echo "$row[product_id]<br>";
	echo "$row[artist]<br>";
	echo "<br>";
	}
}

Anyone an idea how i can get this into 3 coloms? I don't know how to do this, cause it counts the total nrs per product_id to print out of the nr row

thx

Bunkermaster

try to use <TD></TD> around your values...

<br> is line break, new line in the browser so it will display a lot of lines...

Bluelove

i got a code to display normal results in a 3 colomn table
but it doesn't work for this one cause it counts the numbers from the tabel too, so i don't know how to code this, simply adding TD won't get me to the result 🙂

Bunkermaster

please, try to explain more precisely what code you have and what output you need

Bluelove

Ok i try again 🙂
I want to make a label page
I have a table that contains a product_id and a nr (= total number of labels to print of this product)

i make the query, execute it and then output it with this code :

echo "<table border='1'>";
while($row = mysql_fetch_array($result)) {
		for ($i = 1; $i <= $row[nr]; $i++) { 		
echo"<tr><td>";
    	echo "$row[product_id]<br>";
		echo"</td></tr>";
	}
}
echo "</table>";

the For structure in this code is to print out the product_id as many times as the number on the "nr" row

The output i get is :
230

230

234

235

280

...
the numbers are the product nrs

Now how do i code that the output will look like :
230 230 230

230 234 235

280

Hope i cleared the question now 🙂

Thx