PHP AJAX和mySQL没有返回数据？

Question

I have the following block of PHP:

$word = mysql_real_escape_string(trim($_GET['word']));
    $firstletter = substr('$word', 0, 1);

    $query = "SELECT * FROM `dictionary` WHERE word LIKE '%$firstletter'";
    $result = mysql_query($query) or die(mysql_error().": ".$query);
    $row = mysql_fetch_assoc($result);
    // send back the word to ajax request
    $i = 0;
    $fullLoad = '';
    while ($i < mysql_numrows($result)) {
        $fullLoad = $fullload . '|' . $row['word'];
        $i++;
    }
    echo $fullLoad;

Now, my AJAX call:

$.ajax({
                type: "GET",
                url: "word-list.php",
                data: "word="+ theword,
                success: function(data){ //data retrieved
                    console.log(data);
                            }
    });

Now, lets assume that the missing word variable is apple - so $word = 'apple';

But when the console.log() outputs - all I get is zero, nothing, nada, zip, blahblah

>:(

Answer 1

Try this

 $firstletter = substr($word, 0, 1);