php - MySQL query not updating -
using code:
$sql = mysql_query("update tablename set auth = '$new_auth' index = '$index'");
i printed out variables. it's working correctly, it's not updating auth or playing around code it'll update first result
when i'm having issues queries use or die() trouble shooting. try updating code following:
$sql = mysql_query("update tablename set auth = $new_auth index = $index") or die(mysql_error());
this kick error involving query , give better understanding of problem is.
Comments
Post a Comment