SELECT * from users where firstname = 'Bob' and lastname = 'Smith' and
username = 'bobsmith' and email = 'bob@test.co.uk' and password = 'testing1

$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];

$query1 = "SELECT * from users where firstname = '" .
    $firstname .
    "' and lastname = '" .
    $lastname .
    "' and username = '" .
    $username .
    "' and email = '" .
    $email .
    "' and password = '" . $password;

echo "<BR>Running query ... <BR>" . $query1;
$result1 = mysqli_query($cxn,$query1);
$numrows1 = mysqli_affected_rows($cxn);