<?php
    //select the database we'll be using
    $db = mysqli_connect("localhost", "root", "password", "lcma");

    //set up the initial query and run the query for activated users
    $query1 = "SELECT firstname,lastname,username,password,email FROM single_db WHERE activated = '1'";
    $query1_info = mysqli_query($db, $query1);

    //grab all info in the database as an array
    while($active_array1 = mysqli_fetch_array($query1_info))
    {
        //set the variables
        $a_firstname = $active_array['firstname'];
        $a_lastname = $active_array['lastname'];
        $a_username = $active_array['username'];
        $a_password = $active_array['password'];
        $a_email = $active_array['email'];
        //insert the data into the registered member table
        $a_query = "INSERT INTO multi_db_2 (firstname, lastname, username, password, email) VALUES ($a_firstname, $a_lastname, $a_username, $a_password, $a_email)";
        mysqli_query($db, $a_query);
    }

    //set up the initial query and run the query for unactivated users
    $query2 = "SELECT firstname,lastname,username,password,email FROM single_db WHERE activated = '0'";
    $query2_info = mysqli_query($db, $query2);

    //grab all info in the database as an array
    while($active_array2 = mysqli_fetch_array($query2_info))
    {
        //set the variables
        $na_firstname = $active_array['firstname'];
        $na_lastname = $active_array['lastname'];
        $na_username = $active_array['username'];
        $na_password = $active_array['password'];
        $na_email = $active_array['email'];
        //insert the data into the temporary member table
        $na_query = "INSERT INTO multi_db_1 (firstname, lastname, username, password, email) VALUES ($na_firstname, $na_lastname, $na_username, $na_password, $na_email)";
        mysqli_query($db, $na_query);
    }
?>