change how things is displayed
Posted: 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:
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.
This is my current code:
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
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
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>';
?>