Splitting a php array from mysql query

$emQuery = "SELECT guardian.Email, child.CFName,  guardian.FName
FROM child
INNER JOIN uaccount ON child.ANum = uaccount.ANum
INNER JOIN guardian ON guardian.ANum = uaccount.ANum
WHERE uaccount.ANum = '$ANum'";

$result = mysql_query($query);
$Email = array();
$FName = array();
$CFName = array();
$test = mysql_fetch_array($result, MYSQL_BOTH);
print_r('this is the test '.$test."<br/>");
while($row = mysql_fetch_assoc($test, MYSQL_BOTH))
{
    echo 'this is the row ';
    print_r($row);
    echo '<br/>';
            //$info = mysql_fetch_assoc($rows, MYSQL_BOTH);
            $Email[] = $info['Email'];
            $FName[] = $info['FName'];
            $CFName[] = $info['CFName'];


}

To the best of my understanding this is what you are trying to do.

Some highlights: print_r can only get a reference to a valid php array, no strings included. mysql_fetch_assoc fetches a line out of a result set referenced by a variable, and then moves the reference to point to the next row. You cannot call this function on a the result of it self, as it is not valid syntax.

In general, you'll be better off using PDO or mysqli_ functions at least, as it is by far more secure, by allowing you to use parameter binding instead of just using use input as part as your SQL.

You should just loop through the rows of your result once like so:

$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
    // print_r($row); Debug here if you want.
    $Email = $row['Email'];
    $FName = $row['FName'];
    $CFName = $row['CFName'];
}

Note: You were providing a second parameter to mysql_fetch_assoc() which only takes one parameter (the result from a query). See the doc here.

mysql_fetch_array() takes another parameter that specifies what type of array to return.

Generalized PDO example out of a project of mine ($sql would be your $Query string):

$qry = $pdo->query($sql);
$all=array();
$idx=0;
while($fields=$qry->fetch( 'PDO::FETCH_ASSOC' )){
    $all[key($fields)][$idx]=$fields[key($fields)];
    while(next($fields)!==false){
        $all[key($fields)][$idx]=$fields[key($fields)];
    }
    $idx++;
}

The $all variable will hold an array which in turn holds an array for each of the columns you've selected.

Like that you can do neat things like array_combine($all['Email'],$all['Fname']) and you'd get an array where the key is the Email column and the value would consist of the Fname column.