UPDATE MEMB_CREDITS SET credits = credits + 1000 WHERE memb___id = 'username'
Printable View
cuz your website .php where it reads from credits it doesnt read MEMB_CREDITS it reads other table..
retry this:
Code:$objetivo = mssql_query("SELECT credits FROM MEMB_CREDITS WHERE memb___id" = '$user_auth_id'");
while($resultado = mssql_fetch_assoc($objetivo))
{
echo $resultado[MEMB_CREDITS];