I upgraded to PHP Version 4.0.1pl2 and mysql_affected_rows no longer works.  mysql_num_rows works, but all my pages that query the DB using a DELETE, UPDATE, and INSERT and checking with mysql_affected_rows returns nothing.  It worked when I had PHP3.  Did the format change???


$queryB = "INSERT INTO $userstable (l_name, f_name, title, business, address, city, state, zipcode, bus_tel, bus_fax, email) VALUES ('$l_name','$f_name','$title','$business','$address','$city','$state','$zipcode','$bus_tel','$bus_fax','$email')";
		$resultB = MYSQL_QUERY($queryB);
		@$numberB = MYSQL_AFFECTED_ROWS($resultB);
		PRINT "This is numberB: ".$numberB."<BR>";

		if ($numberB != "1")
			{
			PRINT "<CENTER><H3>Insert into PRSA was unsuccessful.</CENTER></H3>";
			EXIT;
			}
		}
	
	PRINT "<CENTER><H3>Insert was successful!</CENTER></H3>";