[Resolved] Two columns, sorting problem

[Kyrst]

Here is my code:

$result = mysql_query("SELECT DISTINCT myplay.* FROM myplay WHERE 1 ORDER BY track_vol ASC , track_play  ASC");
echo mysql_error();  

echo "<table width=100% class=outside>";
if ($result)
{
  for ($i=0; $i < mysql_num_rows($result); $i +=2)
  {
    $row = mysql_fetch_array($result);
    echo "<tr>";
    echo "<td width=50% align=left class=con>" . $row['track_play'] . "</td>";
    if ((mysql_num_rows($result) % 2) == 0)
    {
      $row = mysql_fetch_array($result);
    echo "<td width=50% align=left class=con>" . $row['track_play'] . "</td>";
    }
    echo "</tr>";
  }
}
echo "</table>";

Now this is displaying the info, but the issue is it appears like this:

track 1 track 2

track 3 track 4

I want it to display in this order:
track 1 track 3

track 2 track 4

another issue I am having is if the row has no info ie I have an odd number of records it doesnt show anything in the second column.

Any help would be appreciated

[drawmack]

pipe the data into an array before printing it

$result = mysql_query("SELECT DISTINCT myplay.* FROM myplay WHERE 1 ORDER BY track_vol ASC , track_play  ASC");
echo mysql_error();  

$list = array();
while($data = mysql_fetch_assoc($result)) {
    $list[] = $data;
} //end while

echo "<table width=100% class=outside>";
for ($i=0; $i < count($list); $i +=2)
  {
    echo "<tr>";
    echo "<td width=50% align=left class=con>" . $list[$i]['track_play'] . "</td>";
    if ((count($list) % 2) == 0)
    {
    echo "<td width=50% align=left class=con>" . $list[$i+1]['track_play'] . "</td>";
    }
    echo "</tr>";
  }
}
echo "</table>";

[Kyrst]

It returned a parse error which I fixed I think, lol, but it is still having the same problem, if the rows are not equal the second column shows nothing and the list still appears in the
track 1 track 2
track 3 track 4

format.

here is the code as it stands, removed the last } as that is where the parse error was.

$result = mysql_query("SELECT DISTINCT myplay.* FROM myplay WHERE 1 ORDER BY track_vol ASC , track_play  ASC");
echo mysql_error();  

$list = array();
while($data = mysql_fetch_assoc($result)) {
    $list[] = $data;
} //end while

echo "<table width=100% class=outside>";
for ($i=0; $i < count($list); $i +=2)
  {
    echo "<tr>";
    echo "<td width=50% align=left class=con>" . $list[$i]['track_play'] . "</td>";
    if ((count($list) % 2) == 0)
    {
    echo "<td width=50% align=left class=con>" . $list[$i+1]['track_play'] . "</td>";
    }
    echo "</tr>";
  }
echo "</table>";

[drawmack]

try this

$result = mysql_query("SELECT DISTINCT myplay.* FROM myplay WHERE 1 ORDER BY track_vol ASC , track_play  ASC");
echo mysql_error();  

$list = array();
while($data = mysql_fetch_assoc($result)) {
    $list[] = $data;
} //end while

echo "<table width=100% class=outside>";
for ($i=0; $i < intval(count($list)/2); $i++)
  {
    echo "<tr>";
    echo "<td width=50% align=left class=con>" . $list[$i]['track_play'] . "</td>";
    if ((count($list) % 2) == 0)
    {
    echo "<td width=50% align=left class=con>" . $list[$i+intval(count($list)/2)]['track_play'] . "</td>";
    }
    echo "</tr>";
  }
echo "</table>";

that should work for any length list that is evenly divisible by 2

i.e.
track 1 track 3
track 2 track 4

track 1 track 4
track 2 track 5
track 3 track 6

[Kyrst]

thank you, so far that has worked.