Re: Database/Table Design for Global Country Statistics

Thanks for the feedback and the suggestions.

A problem I have now when using the new design is the following:

As a result from my PostGres query I get something like this:

year | value | name
---------------------------------------
2001 | 123 | Afghanistan
2002 | 125 | Afghanistan
2003 | 128 | Afghanistan
2004 | 132 | Afghanistan
2005 | 135 | Afghanistan

2001 | 412 | Albania
2002 | 429 | Albania
2003 | 456 | Albania
2004 | 465 | Albania
2005 | 477 | Albania

.....

The way it is displayed on the web (in table form) is the "usual" way:

name 2001 2002 2003 2004 2005
-----------------------------------------------------------------
Afghanistan ....
Albania ....

Is there any "simple", elegant solution for PHP, so that it does this
transformation? I can't imagine that I would have to write a couple
of IFs to achieve that. But I have no other idea. Or is it a question
of writing a more elegant SQL query?

Thanks for any advice!

Stef