Output in several coloms

Bluelove

how do i put the data after a query into several coloms

now i can retreive data and through a "while" structure, all data is outputted row by row

how do i code, that all data should go by several coloms first and then a new row...

thx

(if my sentences aren't clear, i wan't to have something like this output : http://www.only-djs.com/vinyl/new/new.cfm)

JDcrack

The easiest way to do this is probably by setting a counter in your loop

echo "<table><tr>";
$i = 1;
$cols = 4; //number of columns;
while (something){

if ($i > $cols){
echo "<tr>"; //create new row
echo "<td>Data cell $i</td>";
$i = 1; //reset counter;
}else{
echo "<td>Data cell $i</td>";
$i++;
}


} //end while loop
echo "</table>";

you dont have to do this using a table either, you could uses spaces and breaks/new lines

Bluelove

mmm don't quite get it here, sorry 🙂

can you explain a little?
what do i have to put in the while structure, the fetch array?

JDcrack

Sorry about that.... 🙂

Yes your fetch array goes into the while loop...
here is a more complete example:

$i = 1; //sets the counter
$cols = 4; //number of columns;
$result=mysql_query("SELECT * FROM table WHERE this=that");
while ($myrow=mysql_fetch_array($result)){
//the loop will only run while returning results from your mysql query
if ($i > $cols){
echo "<br>"; //create new row
echo " $i ";
$i = 1; //reset counter;
}else{
echo " $i ";
$i++; //add 1 to the counter
}

If you are still not sure or completely understand the while statement...
here is your homework 🙂
These are tutorials that will help you out.
http://www.php.net/manual/en/control-structures.while.php
http://www.zorka.com/home/phptutorial/main/event=lesson/while
http://www.freewebmasterhelp.com/tutorials/php/4

Bluelove

OK thx mate
i changed the code a bit to work in a table
seems to work now
thank you very much