mysql_fetch_array没有返回任何内容

Question

Can someone please help with below query. The code mentioned below is not returning FirstName and LastName. Why?

Cheers, Akhil G

<?php 

        $username = mysql_real_escape_string($_GET['user']);
        $firstname ="" ;
        $lastname ="";
            if (ctype_alnum($username))
            {
                //check user exist

                $check = mysql_query("SELECT username, first_name, last_name FROM syn where username = '$username'");
                if (mysql_num_rows($check) === 1)
                {
                    $get = mysql_fetch_array($check);
                    $username = $get['username'];
                    $firstname = $get['first_name'];
                    $lastname = $get['last_name'];
                } else 
                echo "<h2> User Does Not Exist ! </h2>";
                exit();
            }   
?>

Answer 1

you are using the wrong fetch function

$get = mysql_fetch_array($check);

stored data in numbered positions in the array, so the returned data is stored in $get[0], $get[1] and $get[2].

you can see the contents by using print_r($get);

Instead use

$get = mysql_fetch_assoc($check);

this stores the data in the associated array you require.