Re: Newbie Question $2

Finally figured out what the question was! Here's a better version of your code Ethan: $phn = $_POST['phone']; // note the quotes on the index if (strlen($phn) <> 10) { echo "Error in phone number entry - must be 10 digits"; exit(); } $phn = mysqli_real_escape_string($cxn,$phn); $masked_phone = substr($phn,0,3) . "-".substr($phn,3,3). "-". substr($phn,6,4); $sql1 = "select Lname, Fname from Customers where Phone = '$masked_phone'"; // note use of diff quotes $result1 = mysqli_query($cxn, $sql1); if (mysqli_num_rows($result1) == 0) { echo "Phone number $masked_phone not on file"; exit(); } else { echo "Found {$result1['Fname']} {$result1['Lname']} is on file with number $masked_phone"; exit(); }