function incrUserDeckStat($stat, $dkN, $vstyle, $userId)
{
include 'config.php';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname);
$userDeckStat = getUserDeckStat($stat, $dkN, $vstyle, $userId);
$userDeckStat++;
$query = sprintf("UPDATE user_decks SET stats_correct = '%s' WHERE deck_id = (SELECT id FROM decks WHERE short_name = '%s' OR display_name = '%s') AND vstyle_id = (SELECT id FROM vstyles WHERE vstyle_description ='%s' OR vstyle='%s') AND user_id = '%s'", mysql_real_escape_string($userDeckStat), mysql_real_escape_string($dkN), mysql_real_escape_string($dkN), mysql_real_escape_string($vstyle), mysql_real_escape_string($vstyle), mysql_real_escape_string($userId));
$result = mysql_query($query);
}
<tr class="info">
<th class="text-center" style="vertical-align:middle;">Deck</th>
<th class="text-center">Get Kanji+Reading, Guess English<br /><span class="label label-primary">Easy</span></th>
<th class="text-center">Get Kanji, Guess English<br /><span class="label label-warning">Med</span></th>
<th class="text-center">Get Kanji, Guess Reading<br /><span class="label label-danger">Hard</span></th>
<th class="text-center" style="vertical-align:middle;">Total</th>
</tr><?php
foreach ($pDecksSrtAscArr as $key => $value) {
//key=DkName; value=deckId
//if(getOwnershipStatus($value, $pid)){//firefox needs this otherwise it displays unowned decks
$kanjiRE = getUserDeckStat('stats_correct', $key, 'kanjiRE', $pid);
$kanjiE = getUserDeckStat('stats_correct', $key, 'kanjiE', $pid);
$kanjiH = getUserDeckStat('stats_correct', $key, 'kanjiH', $pid);
$reCnt = getUserDeckStat('stats_correct', $key, 'kanjiRE', $pid);
$eCnt = getUserDeckStat('stats_correct', $key, 'kanjiE', $pid);
$hCnt = getUserDeckStat('stats_correct', $key, 'kanjiH', $pid);
$total = $kanjiRE + $kanjiH + $kanjiE;
?>
<tr class="text-center">
<td class="text-left"><?php
echo $key;
?>
</td>
<td <?php
if ($reCnt < 10) {
echo "class='danger'";
}
?>
> <?php
echo $reCnt;
?>
