il risultato di una query su due colonne...

[pheeko]

Ciao a tutti, ho questo problema...

faccio una query al db, mi mostra i risultati, tutto ok, funziona!

ma se io volessi far incolonnare automaticamente nel browser su due o più colonne come faccio?

di seguito la query col l'html:
------------------------------------------------------------
function all($bgcolor1, $bgcolor2, $bgcolor3, $username) {
global $prefix, $user_prefix, $db, $module_name;
OpenTable();
echo ("
<table align=center border=0 cellpadding=0 cellspacing=10>");
echo ("<td bgcolor=#ffffff width=200>Lista degli Autori</td>");
$sql = "SELECT j.id, j.joid, j.nop, j.ldp, j.ltp, j.micro, u.user_id, u.username FROM ".$prefix."_journal_stats j, ".$user_prefix."_users u where u.username=j.joid ORDER BY 'joid' ASC";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
if ($dcount >= 1000000000) {
echo "</table>";
CloseTable();
journalfoot();
die();
} else {
$dcount = $dcount + 1;
print ("<tr>");
printf ("<td bgcolor=#ffffff><a href=\"modules.php?name=$module_name&file=search&b ywhat=aid&exact=1&forwhat=%s\">%s</a></td>", $row[joid], $row[joid]);
echo "</tr>";
}
}
echo "</table>
";

[Jack Barton]

E' una query di esempio, vedi di adattare il codice con la tua query...

 $conta=1; 
echo"<table border=\"0\" width=\"100%\"><tr>";
$result = sql_query("select * from tabella", $dbi);
    echo "
";
    while (list($var1, $var2, $var3) = sql_fetch_row($result, dbi)) {
echo"<td>$var1 - $var2 - $var3
";
if($conta%2==0)
echo"</td>";
if($conta%2==0)
echo"</tr>";
$conta++;}
echo"</table>"; 

[pheeko]

Ho provato in questo moda, ma me li mette tutti su un' unica riga...

[pheeko]

<?php

if (!eregi("modules.php", $_SERVER[PHP_SELF])) {
die ("You can't access this file directly...");
}

require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
get_lang($module_name);

$pagetitle = "- "._USERSJOURNAL."";

include("header.php");
include("modules/$module_name/functions.php");

cookiedecode($user);
$username = $cookie[1];

startjournal($sitename,$user);

function all($bgcolor1, $bgcolor2, $bgcolor3, $username) {
global $prefix, $user_prefix, $db, $module_name;
OpenTable();
echo ("
<table align=center border=0 cellpadding=0 cellspacing=10>");
echo ("<td bgcolor=#ffffff width=200>Lista degli Autori</td>");
$sql = "SELECT j.id, j.joid, j.nop, j.ldp, j.ltp, j.micro, u.user_id, u.username FROM ".$prefix."_journal_stats j, ".$user_prefix."_users u where u.username=j.joid ORDER BY 'joid' ASC";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
if ($dcount >= 1000000000) {
echo "</table>";
CloseTable();
journalfoot();
die();
} else {

print ("<tr>");
printf ("<td bgcolor=#ffffff><a href=\"modules.php?name=$module_name&file=search&b ywhat=aid&exact=1&forwhat=%s\">%s</a></td>", $row[joid], $row[joid]);
echo "</tr>";
}
}
echo "</table>
";
CloseTable();
}


echo "
";

echo "
";

switch($op) {
case "last":
last20($bgcolor1,$bgcolor2,$bgcolor3, $username);
break;


case "all":
all($bgcolor1,$bgcolor2,$bgcolor3,$sitename, $username);
break;


default:
all($bgcolor1,$bgcolor2,$bgcolor3,$sitename, $username);
break;
}

journalfoot();

?>

[Jack Barton]

<?php 

if (!eregi("modules.php", $_SERVER[PHP_SELF])) { 
die ("You can't access this file directly..."); 
} 

require_once("mainfile.php"); 
$module_name = basename(dirname(__FILE__)); 
get_lang($module_name); 

$pagetitle = "- "._USERSJOURNAL.""; 

include("header.php"); 
include("modules/$module_name/functions.php"); 

cookiedecode($user); 
$username = $cookie[1]; 

startjournal($sitename,$user); 

function all($bgcolor1, $bgcolor2, $bgcolor3, $username) { 
global $prefix, $user_prefix, $db, $module_name; 
OpenTable(); 
$conta=1; 
echo"<table border=\"0\" width=\"100%\"><tr><td bgcolor=#ffffff width=200>";
echo"[b]Lista degli Autori[/b]</td></tr><tr>";

$sql = "SELECT j.id, j.joid, j.nop, j.ldp, j.ltp, j.micro, u.user_id, u.username FROM ".$prefix."_journal_stats j, ".$user_prefix."_users u where u.username=j.joid ORDER BY 'joid' ASC"; 
$result = $db->sql_query($sql); 
while ($row = $db->sql_fetchrow($result)) { 
echo"<td><a href=\"modules.php?name=$module_name&file=search&bywhat=aid&exact=1&forwhat=%s\">%s</a></td>, $row[joid], $row[joid]
";
if($conta%2==0)
echo"</td>";
if($conta%2==0)
echo"</tr>";
$conta++;}
 
echo"</table>";
CloseTable(); 
}

switch($op) { 
case "last": 
last20($bgcolor1,$bgcolor2,$bgcolor3, $username); 
break; 


case "all": 
all($bgcolor1,$bgcolor2,$bgcolor3,$siten
ame, $username); 
break; 


default: 
all($bgcolor1,$bgcolor2,$bgcolor3,$siten
ame, $username); 
break; 
} 

journalfoot(); 

?>

P.S. Quando scrivi il codice sul forum racchiudilo tra [ php ] [ /php ]