query results in two columns

[crawfd]

I  currently have one table with one row of results. How can I subdivide my results into two columns? E.g. maybe tally the results and then based on num rows divde equally and put equal results in both columsn. Thanks

<?	// genres fields
$q="select genreslist from Members where MemberID ='$_SESSION[MemberID]' ";
$row=mysql_fetch_object(mysql_query($q));
$genres_array=split(",",$row->genreslist);
$q1=mysql_query("select * from genres ");

echo "<table border='0' width='100%' cellspacing='0' cellpadding='0' align=center>";
$st="";
while($noticia=mysql_fetch_array($q1)){

if(@$bgcolor=='#f1f1f1'){$bgcolor='#ffffff';}
else{$bgcolor='#f1f1f1';}
if(in_array($noticia['id'],$genres_array)){
echo "$noticia[name], ";
}
}
echo  "</table>"; ?>

[jkurrle]

Pardon my programming differences, but below is how I might write it.

Looking at your code, it looks like you want to sort by the genres in your genre list and list each set of items in multiple rows. Also, it looks like genrelist is a single row that has comma delimited values. I'm doing some guessing as to your table structures, so you will need to interpret my code to better fit your scenario.

Using mysql_fetch_array($result,MYSQL_ASSOC) sets each item in the row to a variable name equal to their column name in their database table. Example, if the column name was ID_Number, the item in that column would be set to variable $ID_Number.

Connect_To_DB() is a function I write to connect to my MySQL server and make my database connection for me. It returns the connection as a variable.

I left out the coloring information, as I'm not sure under what circumstances you want to apply it.

$num_columns="2";

$q="select genreslist from Members where MemberID ='$_SESSION[MemberID]' ";
$connection=Connect_To_DB();
$result=mysql_query($q)
  or die("Select from Members table had errors - ".mysql_error());
mysql_close($connection);

if($row=mysql_fetch_array($result,MYSQL_ASSOC))
  {
  extract($row);
  $genre_array=explode(",",$genrelist);
  }
else $genre_array=array();

echo "<table border='0' width='100%' cellspacing='0' cellpadding='0' align=center>";

foreach($genre_array as $genre_item)
  {
  $q1="select * from genres where genre=\"$genre_item\" ";
  $connection=Connect_To_DB();
  $result=mysql_query($q1)
    or die("Select from genres table had errors - ".mysql_error());
  mysql_close($connection);

  echo "<tr><td><font color=\"red\">$genre_item</font></td></tr>";

  $counter=1;
  while($row=mysql_fetch_array($result,MYSQL_ASSOC))
    {
    extract($row);
    if ($counter%$num_columns==1) echo "<tr>\r\n<td>";
    else echo "<td>";
    echo "$id";
    if ($counter%$num_columns==0) echo "</td>\r\n<\tr>";
    else echo "</td>";
    $counter++;
    }
  if ($counter%$num_columns!=0) echo "</tr>";
  }

echo  "</table>";

You will note I set the variable $num_columns, so you can decide how many columns you want. I hope this code gives you some ideas of how you might want to organize your data.

Good Luck!