[code=php]//sanitize inputs
$userid = mysql_real_escape_string($user_username); // mysql_real_escape_string() needs to be called before mysql_query()
//MySQL Query
$q = “UPDATE table2purchstats SET userid = ‘{$userid}’, purchstat_a = ‘{$purchstat_a}’, purchstat_b = ‘{$purchstat_b}’, purchstat_c = ‘{$purchstat_c}’, purchstat_d = ‘{$purchstat_d}’, purchstat_e = ‘{$purchstat_e}’, purchstat_f = ‘{$purchstat_f}’, purchstat_g = ‘{$purchstat_g}’, purchstat_h = ‘{$purchstat_h}’, purchstat_i = ‘{$purchstat_i}’, purchstat_j = ‘{$purchstat_j}’, purchstat_k = ‘{$purchstat_k}’, purchstat_l = ‘{$purchstat_l}’, purchstat_m = ‘{$purchstat_m}’, purchstat_n = ‘{$purchstat_n}’, purchstat_o = ‘{$purchstat_o}’, purchstat_p = ‘{$purchstat_p}’, purchstat_q = ‘{$purchstat_q}’, purchstat_r = ‘{$purchstat_r}’, purchstat_s = ‘{$purchstat_s}’, purchstat_t = ‘{$purchstat_t}’, purchstat_u = ‘{$purchstat_u}’, purchstat_v = ‘{$purchstat_v}'”;
// Uncomment this next line if you have trouble with your MySQL syntax.
//exit(“<pre style=’font:normal 10pt sans-serif;’>$q</pre>”);
$sqlResult = mysql_query($q, $link) or die( __LINE__.’ ‘.mysql_error() );
}
// Equal to 1 or should it be greater than zero?
//if ( 0 < mysql_affected_rows($sqlResult) ) {
if (mysql_affected_rows($sqlResult) == 1) {
echo “success”;
} else {
echo”failure”;
}
I am getting this error:
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /…/congrats.php on line 98
Line 98:
[code=php]
if (mysql_affected_rows($sqlResult) == 1) {