i need to make this work for name or number

as of now this code works great like i need to fbut it only works for one or the other at the moment it searches for dog number i want to be able to search for the dog number or the dog name if they type the dogs name in i get the dog if they type in the dog number i get the dog <?php require_once("[login to view URL]"); $mysqli = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db); $dognumber=$mysqli->real_escape_string($_GET['dognumber']); $sql="SELECT * FROM checkped WHERE dognumber = \"".$dognumber."\""; $result=$mysqli->query($sql); $dog=mysqli_fetch_assoc($result); if(is_array($dog)) { $momnumber=$mysqli->real_escape_string($dog['momnumber']); $dadnumber=$mysqli->real_escape_string($dog['dadnumber']); if($momnumber!=''){ $msql="SELECT * FROM checkped WHERE dognumber = \"".$momnumber."\""; $mresult=$mysqli->query($msql); $mom=mysqli_fetch_assoc($mresult); } if($dadnumber!=''){ $dsql="SELECT * FROM checkped WHERE dognumber = \"".$dadnumber."\""; $dresult=$mysqli->query($dsql); $dad=mysqli_fetch_assoc($dresult); } } ?>