the code works? the above warnings suggest that ter is a mysql syntax error.
moreover the documentation of mysql_affected_rows suggests that u should supply a valid recource identifier but not a mysql result resource. i.e., the above should be mysql_affected_rows($db)
