Page 1 of 1

change how things is displayed

Posted: Tue May 17, 2011 5:06 am
by zyntrax
Hi i'. making a solutions website for the game "Bubble Blast 2" but at the moment i display all the solutions in this way:

Code: Select all

level: 1-1
Solution: 3-3
Score: 1
Vote: Up Vote: Down

level: 1-1
Solution: 1-1
Score: 0
Vote: Up Vote: Down

level: 1-2
Solution: 2-3
Score: 1
Vote: Up Vote: Down

level: 1-2
Solution: 5-3
Score: -1
Vote: Up Vote: Down
But that takes too much space so i would like to display the solutions like this:
The problem is i don't know how, help would be much appreciated.

Code: Select all

level: 1-1
Solution 1: 3-3             Solution 2: 1-1
Score: 1                       Score: 0
Vote: Up Vote: Down     Vote: Up Vote: Down

level: 1-2
Solution 1: 2-3             Solution 2: 5-3
Score: 1                       Score: -1
Vote: Up Vote: Down     Vote: Up Vote: Down
This is my current code:

Code: Select all

<?php
include 'mysqlcon.php';
$query = "SELECT * FROM pack WHERE pack = 1 ORDER BY level ASC, id ASC;";
if($result = mysql_query($query))  
{
	if($success = mysql_num_rows($result) > 0) 
	{
		while ($row = mysql_fetch_array($result))
		{
			echo 'level: '.$row[pack].'-'.$row[level].'<br>';
			echo 'Solution: '.$row[colrow1].' '.$row[colrow2].' '.$row[colrow3].' '.$row[colrow4].' '.$row[colrow5].' '.$row[colrow6].' '.$row[colrow7].' '.$row[colrow8].' '.$row[colrow9].' '.$row[colrow10].'<br>';
			$id = $row[id];
			$query2 = "SELECT * FROM vote WHERE id = ".$row[id].";";
			if($result2 = mysql_query($query2))
			{
				if($success2 = mysql_num_rows($result2) > 0)
				{
					while ($row2 = mysql_fetch_array($result2))
					{
						$up = $row2[up];
						$down = $row2[down];
						$results = $up - $down;
						if($result < -10)
						{
							mysql_query("DELETE FROM pack WHERE id = $id");
						}
						else
						{
							echo 'Score: '. $results .'<br>';
							echo 'Vote: <a href="voteup.php?voteid='.$id.'">Up</a> Vote: <a href="votedown.php?voteid='.$id.'">Down</a><p>';
						}
					}
				}
				else
				{	
					echo 'No votes <br>';
					echo 'Vote: <a href="voteup.php">Up</a> Vote: <a href="votedown.php">Down</a><p>';
				}
			}
		}
    }
    else { echo 'No results found.'; }
}
else { echo 'Failed to get level'; }

echo '<a href="index.php">Back</a>';
?>

Re: change how things is displayed

Posted: Tue May 17, 2011 6:10 am
by Kastor

Code: Select all

<?php
include 'mysqlcon.php';
$query = "SELECT * FROM pack WHERE pack = 1 ORDER BY level ASC, id ASC;";
echo '<table border="0">';
if($result = mysql_query($query))  
{
   if($success = mysql_num_rows($result) > 0) 
   {
      $first_col = true;
      while ($row = mysql_fetch_array($result))
      {
         if ($first_col) echo "<tr>";
         echo '<td>';
         echo 'level: '.$row[pack].'-'.$row[level].'<br>';
         echo 'Solution: '.$row[colrow1].' '.$row[colrow2].' '.$row[colrow3].' '.$row[colrow4].' '.$row[colrow5].' '.$row[colrow6].' '.$row[colrow7].' '.$row[colrow8].' '.$row[colrow9].' '.$row[colrow10].'<br>';
         $id = $row[id];
         $query2 = "SELECT * FROM vote WHERE id = ".$row[id].";";
         if($result2 = mysql_query($query2))
         {
            if($success2 = mysql_num_rows($result2) > 0)
            {
               while ($row2 = mysql_fetch_array($result2))
               {
                  $up = $row2[up];
                  $down = $row2[down];
                  $results = $up - $down;
                  if($result < -10)
                  {
                     mysql_query("DELETE FROM pack WHERE id = $id");
                  }
                  else
                  {
                     echo 'Score: '. $results .'<br>';
                     echo 'Vote: <a href="voteup.php?voteid='.$id.'">Up</a> Vote: <a href="votedown.php?voteid='.$id.'">Down</a><p>';
                  }
               }
            }
            else
            {   
               echo 'No votes <br>';
               echo 'Vote: <a href="voteup.php">Up</a> Vote: <a href="votedown.php">Down</a><p>';
            }
         }
         echo '</td>';
          if (!$first_col) echo "</tr>";
          $first_col = !$first_col; 
      }
      if (!$first_col) echo "<td></td></tr>"; 
    }
    
    else { echo '<tr><td>No results found.</td></tr>'; }
}
else { echo 'Failed to get level'; }
echo '<\table>';
echo '<a href="index.php">Back</a>';
?>

Re: change how things is displayed

Posted: Tue May 17, 2011 6:29 am
by zyntrax
Thanks for the try.
Hey now it displays it like this:

Code: Select all

level: 1-1
Solution: 3-3
level: 1-1
Solution:
level: 1-1
Solution: 1-1
level: 1-2
Solution: 2-3
level: 1-2
Solution: 5-3
level: 1-2
Score: 1
Vote: Up Vote: Down;
Score: -2
Vote: Up Vote: Down;
Score: 0
Vote: Up Vote: Down;
Score: 1
Vote: Up Vote: Down;
Score: -1
Vote: Up Vote: Down;
Score: 0
Vote: Up Vote: Down; 
I would like it if all results from the same level show up on the same row and a new row for the next level.
Thanks