The issue I am having is that I want to be able to add all of the rows that start with “event_”, here is what I have so far.
[php]
$result = mysql_query(“SELECT event_* FROM students WHERE studentid = ‘$sid’”) or die(mysql_error());
while($row = mysql_fetch_array( $result ))
{
$totalpoints = $totalpoints + $row[‘event_*’];
}
echo $totalpoints;
[/php]
The reason I need a variable is because there will be more columns added every some often from a panel.