Columns

[mdub2112]

In trying to search for an answer to my question...I mostly found one

http://www.phpbuilder.com/board/showthread.php?t=10325166

I'm trying to do it in descending order

I'm currently displaying two columns with a part of a database row in each column.
e.g REC1 REC1 (I could only figure out how to display nicely doing it this way).

I would like it to be like

REC1 REC1 REC4 REC4
REC2 REC2 REC5 REC5
REC3 REC3

I also have alternating row colors.

Can anyone help??

Current code attached

[bpat1434]

Search the board for vertical Horizontal Loop.... I have already posted, twice, a function that takes an array and formats it vertically or horizontally.

Here's a link: http://phpbuilder.com/board/showpost.php?p=10723404&postcount=14

You should be able to utilize that function to do what you want.

[mdub2112]

That basically did the trick.

The data I'm trying to pull out are employee names and their extensions
Of which are split up into three diff fields within the dbase (first, last, and ext).
I have a variable that combines the first name + last name.

So, now it's just the full name and extension I need to show. I want it to appear as four columns.

fullname1 ext1 fullname4 ext4
fullname2 ext2 fullname5 ext5
fullname3 ext3

Where the fullname and ext appear in two different columns

My Current Code

include_once('../connects/db_directory.php');
$query = "select * from employees where ext is not null order by first_name";
$result = $db->query($query);
$emp = $result->fetch_assoc();
$color1 = "#E3D9CA"; 
$color2 = "#F8F8F8"; 
$color_count = 0; 


//while($r=mysql_fetch_array($getpress)) {
while ($emp = $result->fetch_assoc())
{
$fullname = $emp['first_name']." ".$emp['last_name'];
$row_color = ($color_count % 2) ? $color1 : $color2;

  $theArray[] = '<span bgcolor="$color1";">'.$fullname.'</span>
<span bgcolor="$color2";">'.$emp['ext'].'  </span><br>';
$color_count++;
}

// Now just output either a vertical or horizontal table:
vertHorizLoop($theArray, 2, 0, 1);
// Use $theArray to construct a 2 column NON-horizontal (Vertical) table 

Everything above the include is identical to the code you provided in
http://phpbuilder.com/board/showthread.php?t=10331282&highlight=vertical+Horizontal+Loop
above the //Your Code section

Which basically gets all the info I wanted in to two columns.
I'm getting results like

fullname1 ext1 fullname4 ext4
fullname2 ext2 fullname5 ext5
fullname3 ext3

Where the fullname and ext are showing with a single space in between.
I didn't get the colors to work either; however, that's a different pot of gumbo

[bpat1434]

Glad to hear the function is working for you.

[mdub2112]

Any idea on how to get it to fully work for me?

[bpat1434]

You'd have to make sure your array was set up correctly (or make sure you have a divider so you can split the string). Then just modify the function so it outputs two columns instead of one with the first part of the string in the first column, and the second part of the string in the second column.

As an example

<?php

function vertHorizLoop($array, $cols=3, $split=null, $horiz=true, $table=true)
{
    $output = '';
    // Define some defaults
    $count = count($array);
    if($table)
        $output .= '
<table>
    <tr>';
    if(!$horiz)
    {
        $sect = array();
        for($i=0; $i<$cols; $i++)
            $sect[$i] = array();

    $max = ceil($count/$cols);
    $k=0;

    for($i=0; $i<$count; $i++)
    {
        if($i%$max==0 && $i!=0)
            $k++;

        $sect[$k][] = $array[$i];
    }
}

if($horiz)
{
    for($i=0; $i<count($array); $i++)
    {
        if($i%$cols==0)
        {
            if($table)
                $output .= '
</tr>
<tr>';
            else
                $output .= '<br>';
        }
		if($split !== null) {
			list($first, $scnd) = explode($split, $array[$i]);

			if($table)
				$output .= '
		<td>'.$first.'</td>
		<td>'.$scnd.'</td>';
			else
				$out .= $first.' '.$scnd.' ';
		}
		else {
			if($table)
				$output .= '
		<td>'.$array[$i].'</td>';
			else
				$output .= $array[$i].' ';
		}
    }
}

else
{
    for($i=0; $i<$max; $i++)
    {
        foreach($sect as $key=>$arr)
        {
			if($split !== null) {
				list($first, $scnd) = explode($split, $arr[$i]);

				if($table)
					$output .= '
		<td>'.$first.'</td>
		<td>'.$scnd.'</td>';
				else
					$output .= $first.' '.$scnd.' ';
			}
			else {
				if($table)
					$output .= '
		<td>'.$arr[$i].'</td>';
				else
					$output .= $arr[$i].' ';
			}
        }
        if($table)
            $output .= '
</tr>
<tr>';
        else
            $output .= '<br>';
    }
}

if($table)
    $output .= '
</tr>
</table>';
    echo $output;

}

$array = array('name1<|>value1', 'name2<|>value2', 'name3<|>value3', 'name4<|>value4', 'name5<|>value5', 'name6<|>value6', 'name7<|>value7', 'name8<|>value8', 'name9<|>value9', 'name10<|>value10');

vertHorizLoop($array, 2, '<|>', false, true);

?>

Gives you this output:

name1  	value1  	name6  	value6
name2 	value2 	name7 	value7
name3 	value3 	name8 	value8
name4 	value4 	name9 	value9
name5 	value5 	name10 	value10