[Resolved] Disable Repeated Values from Showing

bpat1434

Hey guys and gals.

I'm having a little trouble here.

I want to do the following:

Display a table that lists different songs. I want them to be output so that in the far left hand column is the year, and then there are 5 other columns with info provided through the database. Easy enough, I can do that.
Viewable Here: http://umbcmamasboys.org/test.php

Now I want to modify the script so that you don't see repeats of the same year. Here's an Example:

So I have the code to already view all the information. So here's the question:
How do I edit the code so that I don't see a repeat of the same year?

<?php

$db_conn = mysql_connect('localhost', 'db_user', '********');
mysql_select_db('db_db', $db_conn);

$query = 'SELECT * FROM `music_repertoire` ORDER BY `Year`';
$result = mysql_query($query);

echo '<table width="100%" border="1">'."\n".
	'<tr><th>Year Performed</th><th colspan="5">Song Information</th><tr>'."\n".
	'<tr><td bgcolor="#CCCCC"></td><th>Title</th><th>Artist</th><th>Album</th><th>Arranger</th><th>Download Clip</th></tr>'."\n";

while($song = mysql_fetch_array($result)){
	echo '<tr>'.
		'<td>'.$song['Year'].'</td>'.
		'<td>'.$song['Title'].'</td>'."\n".
		'<td>'.$song['Artist'].'</td>'."\n".
		'<td>'.$song['Album'].'</td>'."\n".
		'<td>'.$song['Arranger'].'</td>'."\n".
		'<td><a href="'.$song['Clip'].'">Download Now</a></td>'."\n".
		'</tr>';
}

echo '</table>';

?>

Thanks for the help.

~Brett

Frederick

Do a loop placing a GROUP BY year.
Place another loop inside that loop to query the selections referencing the array variable.

echo "<table>\n";
$sql = mysql_query("SELECT * FROM table GROUP BY year DESC") or die (mysql_error());
while ($row = mysql_fetch_array($sql)) {
    echo "<tr>\n";
    echo "<td>".$row["year"]."</td>\n";
    echo "<td valign=\"top\">\n";
    echo "<table>\n";
    $selsql = mysql_query("SELECT * FROM table WHERE id = ".$row["id"]."") or die (mysql_error());
    while ($sel = mysql_fetch_array($selsql)) {
        echo "<tr>\n";
        echo "<td>".$sel["title"]."</td>\n";
        echo "</tr>\n";
    }
    echo "</table>\n";
    echo "</td>\n";
    echo "</tr>\n";
}
echo "</table>\n";

bpat1434

Thank you works like a charm now. I had to edit some things, but you got me going in the right direction.

I first tried with a for() loop, but didn't think to go with a while() within a while(). Who'd a thunk it?

Thanks.

~Brett