Is this possible - data manipulation

[james0816]

I have the following information in my db:

a b c
2003 5 1
2003 9 1
2004 2 1
2004 6 1
2004 8 2
2005 4 2

I'm currently displaying totals as such:

a b c
2003 14 1
2004 8 1
2004 8 2
2005 4 2

What I am wondering or would like to do is display like this:

a b c
2003 14 1
2004 8 1
- 8 2 <- where either a dash or a space will
2005 4 2 substitute the duplicate date


Is that possible?

Thx

 

[Vragabond]

Just do a simple if sentence:

$year = 0;
if ($year != $row['year'])
{
   echo $year;
}
else
{
   echo "-";
}
$year = $row['year']

 

[james0816]

ty very much...exactly what i'm looking for.