Hey guys, I have a little page set up (http://www.betheband.org/quickcontacts.php) and I want the results to be shown in 2 different columns, how can I go about this?

You could probably just get the total number of rows your going to show, divide in half and use that number as an index. Then output the first row in a table cell, and the one in the middle in the next table cell. For the next table row, you output the seccond row in a table cell then the middle plus one in the other table cell.

Something like this

PHP Code:

$numRows = 20; // Example, normaly you would use a database query to find this out
$middleIndex = $numRows / 2; // Which is 10

echo "<table>"
for($index=0; $index < $middleIndex; $index++) {
    echo "<tr>";
    echo "<td>".$someResult[$index]."</td>";
    echo "<td>".$someResult[$middleIndex]."</td>";
    echo "</tr>";
    $middleIndex++;
}
echo "</table>";

/*
Which give a table like this
0   10
1   11
2   12
3   13
4   14
5   15
6   16
7   17
8   18
9   19

If there is an unevan number of rows, lets say 19 instead of 20,
table cell number 19 above would be empty.

*/ 


Or actually, you should calculate $middleIndex as

PHP Code:

$middleIndex = (int)(($numRows+1) / 2); 


Thanks for the great response.. What if I was to display the data in a div of CSS instead?

    <div id="left">
    
<?php

	$query = safe_query("SELECT * FROM `table` ORDER BY `manager_name` ASC ");
		while($p=mysql_fetch_array($query)) {
			$user = $p['manager_name'];

?>

    <p><a href="javascript:;" onClick="opener.location.href='sendmoney.php?who=<?php echo "$user"; ?>';window.close();" target="_parent"><?php echo "$user"; ?></a></p>

<?php
	
	}

?>

  </div>
    
  <div id="right">
<?php

	$query = safe_query("SELECT * FROM `table` ORDER BY `manager_name` ASC ");
		while($p=mysql_fetch_array($query)) {
			$user = $p['manager_name'];

?>

    <p><a href="javascript:;" onClick="opener.location.href='sendmoney.php?who=<?php echo "$user"; ?>';window.close();" target="_parent"><?php echo "$user"; ?></a></p>

<?php
	
	}

?>
</div>

Is what I have at the moment, and needless to say, it just shows 2 columns of the same names.

I dont know if what you're doing would be faster or not than my idea but its a shot. Instead of hitting the db twice for the information you could do this. And instead of using the * which is a wildcard character, you seem to only be wanting the manager_name so get only that.

PHP Code:

<?php
 $query = safe_query("SELECT 'manager_name' FROM `table` ORDER BY `manager_name` ASC ");
 $user = array();
 while($p=mysql_fetch_array($query)) {
  array_push($user, $p['manager_name']);
 }
 $display = "";
 for ($user as $value) {
  $display .= "\t\t<p><a href=\"javascript:;\" onClick=\"opener.location.href=\'sendmoney.php?who=". $value ."\"';window.close();\" target=\"_parent\">". $value ."</a></p>\n";
 }
?>
 <div id="left">
<?php echo $display; ?>
 </div>
 
 <div id="right">
<?php echo $display; ?>
 </div>

castis example will speed things up, and combined with my first example you could get it into two columns. I'll make another example, writing code the way I'm used to but feel free to change it the way you like it.

PHP Code:

$query = "SELECT manager_name FROM table ORDER BY manager_name";
$result = mysql_query($query);
$numRows = mysql_num_rows($result);
$middleIndex = (int)(($numRows+1) / 2);

$names = array();
while($row = mysql_fetch_assoc($result)) {
    $names[] = $row['manager_name'];
}

// Now lets print the left column

echo "<div id=\"left\">\n";
for($i = 0; $i < $middleIndex; $i++) {
    echo "<p><a href=\"#\" "
       . " onClick=\"opener.location.href='sendmoney.php?who="
       . $names[$i] . "';window.close();\"></a></p>\n";
}
echo "</div>\n";

// And the right one

echo "<div id=\"right\">\n";
for($i = middleIndex; $i < $numRows; $i++) {
    echo "<p><a href=\"#\" "
       . " onClick=\"opener.location.href='sendmoney.php?who="
       . $names[$i] . "';window.close();\"></a></p>\n";
}
echo "</div>\n"; 


I realized last night that i put in some serously unnecessary crap in that code up there. Here's a revised version.

PHP Code:

<?php
 $query = safe_query("SELECT 'manager_name' FROM `table` ORDER BY `manager_name` ASC ");
 $display = '';
 while($p=mysql_fetch_array($query)) {
  $display .= "\t\t<p><a href=\"javascript:;\" onClick=\"opener.location.href=\'sendmoney.php?who=". $p['manager_name'] ."\"';window.close();\" target=\"_parent\">". $p['manager_name'] ."</a></p>\n";
 }
?>
 <div id="left">
<?php echo $display; ?>
 </div>
 
 <div id="right">
<?php echo $display; ?>
 </div>