Spliting Results into Coulmns

[studiobanks]

Can some one show me how to display results from a mysql query into two html table colums?

Here is how i would like the results returned:

A G
B H
C I
D J
E K
F L

and so on.

[cgraz]

<?

mysql_connect($server, $username, $password) or die("Couldn't connect");

mysql_select_db($database) or die("couldn't select database");

$query = mysql_query("SELECT * FROM yourtable");

   echo "<table width=200 cellpadding=0 cellspacing=0 border=0>\n";

while($a_row=mysql_fetch_array($query)) {

   print "<tr>\n";
   print "<td width=100>" . $a_row["A"] . "</td>\n";
   print "<td width=100>" . $a_row["G"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["B"] . "</td>\n";
   print "<td width=100>" . $a_row["H"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["C"] . "</td>\n";
   print "<td width=100>" . $a_row["I"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["D"] . "</td>\n";
   print "<td width=100>" . $a_row["J"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["E"] . "</td>\n";
   print "<td width=100>" . $a_row["K"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["F"] . "</td>\n";
   print "<td width=100>" . $a_row["L"] . "</td>\n";
   print "</tr>\n";

// end while loop
}

// end table
   echo "</table\n";

?>

Note the while loop returns an array $a_row which can be called using $a_row["field_name"]

Cgraz

[studiobanks]

ok sorry. I was unclear.

The letters were just to show how I need the records returned. They are not feild names. Basicly I need to break the query into two colums because the table becomes to long when each record that is returned into it's own row.

Let me know if I'm not explianing well.

[cgraz]

Note the while loop returns an array $a_row which can be called using $a_row["field_name"]

Still works the same way.

<?

mysql_connect($server, $username, $password) or die("Couldn't connect");

mysql_select_db($database) or die("couldn't select database");

$query = mysql_query("SELECT * FROM yourtable");

   echo "<table width=200 cellpadding=0 cellspacing=0 border=0>\n";

while($a_row=mysql_fetch_array($query)) {

   print "<tr>\n";
   print "<td width=100>" . $a_row["field1"] . "</td>\n";
   print "<td width=100>" . $a_row["field7"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["field2"] . "</td>\n";
   print "<td width=100>" . $a_row["field8"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["field3"] . "</td>\n";
   print "<td width=100>" . $a_row["field9"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["field4"] . "</td>\n";
   print "<td width=100>" . $a_row["field10"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["field5"] . "</td>\n";
   print "<td width=100>" . $a_row["field11"] . "</td>\n";
   print "</tr>\n";

   print "<tr>\n";
   print "<td width=100>" . $a_row["field6"] . "</td>\n";
   print "<td width=100>" . $a_row["field12"] . "</td>\n";
   print "</tr>\n";

// end while loop
}

// end table
   echo "</table\n";

?>

Format the code any way you want. You should be able to see how the code works and format it to your particular needs.

Cgraz