Checking username:
$sql = "SELECT username FROM ACCOUNTDATA WHERE username='$username'";
$result = $db->query($sql);

Inserting data into the database:
$sql = "INSERT INTO ACCOUNTDATA(username, firstname, lastname, email, password)
VALUES ('$username', '$firstname', '$lastname', '$email', '$password')";