Page 1 of 1

(Solved)Mysql display everything from a row with certain val

Posted: Wed May 11, 2011 5:02 am
by zyntrax
Hi i have table called pack, with columns (pack, level, colrow1, colrow2, colrow3, colrow4, colrow5, colrow6, colrow7, colrow8, colrow9, colrow10)
i want to display everything from a row like this.

for example where pack is equal 1
I want it to display it like this:

Level: 'level'
'colrow1'
'colrow2'
'colrow3'
'colrow4'
'colrow5'
'colrow6'
'colrow7'
'colrow8'
'colrow9'
'colrow10'

Level: 'level'
'colrow1'
'colrow2'
'colrow3'
'colrow4'
'colrow5'
'colrow6'
'colrow7'
'colrow8'
'colrow9'
'colrow10'
and so on

How would i do that?
I hope you understand :)

Re: (Solved)Mysql display everything from a row with certain

Posted: Wed May 11, 2011 8:07 am
by zyntrax
I found the solution:

Code: Select all

<?php
include 'mysqlcon.php';
$query = "SELECT * FROM pack WHERE pack = 1;";
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].'<p>';
			include 'Voting.php';
		}
    }
    else { echo 'No results found.'; }
}
else { echo 'Failed to get level'; }
echo '<a href="index.php">Back</a>';
?>