Alternating Table Columns via while() Loop - Webmaster Forum - Web Design, Programming and SEO forums

03-30-2005, 03:12 AM

Jon Mooring

Status: I'm new around here
Join date: Jan 2005
Location:
Expertise:
Software:

Posts: 14

iTrader: 0 / 0%

Jon Mooring is on a distinguished road

Alternating Table Columns via while() Loop

I am writing a script that displays items for sale in each category. Obviously, the items are gathered from the database and put into a variable via a while() loop. What I want to do is put them into two seperate variables. One for each of two table columns. I want every other item to alternate. Like:

item 1 -> column 1
item 2 -> column 2
item 3 -> column 1
etc, etc ,etc...

How would I go about doing this? Thanks in advance.

03-30-2005, 04:07 AM

Travis

Status: Member
Join date: Jul 2004
Location:
Expertise:
Software:

Posts: 445

iTrader: 0 / 0%

Travis is on a distinguished road

Assuming this is done with php and with a database something like this(please note I have not done php for a while and this is off the top of my head):

PHP Code:


			
<?



/*

 * Some sought of database connection/query up here

 * or perhaps an array or something to store the items

 */



$column1 = "<td>";

$column2 = "<td>";



$i = 1;

while($row = mysql_fetch_array()) {

   if($i = 1) {

      $column1 .= $row[item] . "<br>";

      $i = 2;

   } else {

      $column2 .= $row[item] . "<br>";

      $i = 1;

   }

}



$column1 .= "</td>";

$column2 .= "</td>";



/*

 * Then you would have a table down here some where

 * and you would print out the 2 column variables

 */

?>