Remember data MySQL column

Hi everybody,
I have a PHP question and I can't figure it out. I have a simple quiz and based on the answers, I want to show a total score.
I have a MySQL database with 4 columns, for example:
Col1 | Col2 | Col3 | Col4
4 | 2 | 3 | 2
4 | 2 | 2 | 3
4 | 2 | 1 | 1
Now I want to count the columns together based on an if-statement:
if ($_POST['vraag1'] == "question1") {
$data = mysql_query("SELECT Col1 FROM test") or die(mysql_error());
}
if…
Remember data MySQL column

See original post by Vistavision