Please help!

Anon

I posted a message at devshed with a problem and I still don't have an answer. Here's a link to the thread so I don't have to re-explain my problem:

http://forums.devshed.com/showthread.php?s=&threadid=34062&forumid=4

Does anyone know how to solve this? I'd GREATLY appreciate any thoughts. Thank-you!

Anon

This is s bit sloppy but it should work for you...

<table border="1" cellpadding="2" cellspacing="2">
$query = "
SELECT DISTINCT artist FROM music
WHERE $where
ORDER BY artist";

$result1 = mysql_query($query, $link_id);

while ($rows = mysql_fetch_array($result1)) {
$thisartist = $rows["artist"];

$countquery = "SELECT COUNT(*) as thiscount from music where artist = '$thisartist'";
$result2 = mysql_query($countquery, $link_id);

while ($rows2 = mysql_fetch_array($result2)) {
$artistcount = $rows2["thiscount"];
}
?>
<tr>
<td rowspan="<?PHP echo $thiscount;?>" valign="top"><b><?PHP echo $thisartist;?></b></td>

<?PHP
$titlequery = "
SELECT title FROM music
WHERE $where
ORDER BY title";

$result3 = mysql_query($titlequery, $link_id);

while ($rows3 = mysql_fetch_array($result3)) {
$thisartist = $rows3["title"];
?>
<td><?PHP $title;?></td>
</tr>
<tr>
<?PHP
}
}
?>
</tr>
<tr>
<td rowspan="1" valign="top"><b>Pearl Jam</b></td>
<td>Ten</td>
</tr>
</table>

Anon

woops -

<?PHP echo $thiscount;?>
should be
<?PHP echo $artistcount;?>

majik-sheff

Hope this is a good solution:

$sql = "select artist, title, genre FROM music ORDER BY artist, title";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
	if (strtolower($row["artist"]) == $last_artist) {
		echo "- {$row["title"]}<br>\n";
	} else {
		echo "{$row["artist"]}<br>\n";
		echo "- {$row["title"]}<br>\n"; //<----This is your first item
		$last_artist = strtolower($row["artist"]);
	}
}

majik-sheff

Alternately, if you JUST want the first album of a given artist as a seperate item, you can use this sql statement and it will give you what you want. Just substitute $artist with whatever variable you use (this search is not case sensitive). My first solution is far more efficient at formatting the way you describe than any routine that actually explicitly checks first lines.
Good luck!

$sql = "select artist, title, genre FROM music WHERE artist LIKE '$artist' ORDER BY artist, title LIMIT 1";