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

Popular posts from this blog

ios - UICollectionView Self Sizing Cells with Auto Layout -

node.js - ldapjs - write after end error -

DOM Manipulation in Wordpress (and elsewhere) using php -