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? Quote Link to comment 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> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.