PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
zyntrax
Forum Commoner
Posts: 32 Joined: Wed Apr 13, 2011 2:23 am
Location: Sweden
Post
by zyntrax » Tue May 17, 2011 5:06 am
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>';
?>
Kastor
Forum Newbie
Posts: 24 Joined: Thu May 01, 2008 2:29 am
Location: Grodno, Belarus
Contact:
Post
by Kastor » Tue May 17, 2011 6:10 am
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>';
?>
zyntrax
Forum Commoner
Posts: 32 Joined: Wed Apr 13, 2011 2:23 am
Location: Sweden
Post
by zyntrax » Tue May 17, 2011 6:29 am
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