$query = "insert into register (fname, lname, city, state, email, age, gender, newprodver, reference) values ('$fname', '$lname', '$city', '$state', '$email', '$age', '$gender', '$epv', '$refer')";

$result = mysql_query($query) or die(mysql_error());

if ( is_resource($result) )
  echo mysql_affected_rows($result);