bothwell Posted July 6, 2008 Share Posted July 6, 2008 $dbUpdate = "UPDATE tenant_info SET name ='$strName', houseno='$strHouseno', street='$strStreet', area='$strArea', town='$strTown', postcode='$strPostcode', teld='$strTeld', email='$strEmail', beds=$intBeds, rent=$intRent, checkemail='$CheckEmail', checkmail='$CheckMail', checksms='$CheckSMS'" ; $dbUpdate .= " WHERE tenant_id = '$strID' LIMIT 1"; mysql_query($dbUpdate) or die(mysql_error()); Right after I run this query, I echo out the variables passed to check they're there (which they are), and I also run a mysql_affected_rows(); with returns a 0 ??? There's no die immediately after the update query, but no update happens either. What have I done wrong? Link to comment https://forums.phpfreaks.com/topic/113428-solved-whats-wrong-with-this-sql-syntax/ Share on other sites More sharing options...
bothwell Posted July 6, 2008 Author Share Posted July 6, 2008 $dbUpdate = "UPDATE tenant_info SET name ='$strName', houseno='$strHouseno', street='$strStreet', area='$strArea', town='$strTown', postcode='$strPostcode', teld='$strTeld', email='$strEmail', beds=$intBeds, rent=$intRent, checkemail='$CheckEmail', checkmail='$CheckMail', checksms='$CheckSMS'" ; $dbUpdate .= " WHERE tenant_id = '$strID' LIMIT 1"; mysql_query($dbUpdate) or die(mysql_error()); Right after I run this query, I echo out the variables passed to check they're there (which they are), and I also run a mysql_affected_rows(); with returns a 0 ??? There's no die immediately after the update query, but no update happens either. What have I done wrong? Take the single quotes away from $strID since it's an integer rather than a string </eviltwin> Link to comment https://forums.phpfreaks.com/topic/113428-solved-whats-wrong-with-this-sql-syntax/#findComment-582818 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.