$query1="SELECT * FROM $clean_title WHERE lname='$last_name' AND fname='$first_name' AND first='yes'";
$result1=mysql_query($query1) or die(mysql_error());
if (mysql_num_rows($result1) > 0)
        {
        if ($new="yes")
                {
                echo'
                This character has already been entered as new
                ';
                }
                else
                {
                echo'
                Character can be entered into database
                ';
                }
        } 
        else
        {
        echo'
        Character can be entered into database
        ';
        }
 
mysql_close();