While and If mixing...

[Ukoku]

I've got a website that archives stories. When a user uploads a story, its info is added into a table: title, chapter, etc.

At the moment, the stories appear on the author's website in a list. Even stories with different chapter numbers appear separate.

I'd like to make an If statement to say, If there is more than one story with the same Title, simply list the story's chapter number next to the first entry. (Does that make sense?)

Example... right now:
Title Chapter
My story 1
My story 2

How I want it:
My story 1, 2

The code I've got going now is just a simple while.

$fics = mysql_query("SELECT * FROM archive WHERE author='$profile'",$db); 

while ($myrow = mysql_fetch_array($fics)) { 

printf("<tr><td align=\"center\">%s</td><td align=\"center\"><a href=\"archive/%s\">%s</a></td><td align=\"center\">%s/%s</td><td align=\"center\">%s</td><td align=\"center\">%s</td></tr><tr><td colspan=\"5\" align=\"right\"><span class=\"word\">%s</span></td></tr>", $myrow["title"], $myrow["fic"], $myrow["chap"], $myrow["genre"], $myrow["sub"], $myrow["mov"], $myrow["warn"], $myrow["summary"]); 

} 

How can I add this If statement?

[vaska]

If I understand what you are saying you could just do a GROUP by field_title_name on your query and that would make any duplicates into just one for your output.

Otherwise, you would need to create an array and then compares the elements and then do your IF stuff...

I think you are looking for the GROUP option though, but I could be wrong too...

Good luck...v

[mrhappiness]

if you want all chapoters of every story to be displayed and also want to have a new line after the last chapter of every story than group by is not what your'le looking for

$sql="SELECT * FROM archive where archive='".$profile."'";
$result = mysql_query($sql);
$old_title="something that won't be used as title in a million years";
while ($row = mysql_fetch_assoc($result))
{
  if ($row['title'] != $old_title)
  {
    $old_title = $row['title'];
    echo '<br />'.$row['title'].' '.$row['chapter'];
  }
  else
    echo ', '.$row['chapter'];
}

do you want it like this?