选择没有结果

Question

I've tried this for hours. I can connect to my data base and insert into it but can't seem to get anything out of it.

// Declarations
    $connection = mysql_connect("xxxxxxx", "xxxxxxx", "xxxxxxxx");
    mysql_select_db("kettle_test1", $connection);
    if (!$connection)
        {
        die ('Cold not connect: ' . mysql_error());
        }
    else
    {
    echo "connected <br> <br>";
    }



// INSERT   

    mysql_query("INSERT INTO bob2 (Danumber)
    VALUES ('32234245')");

// QUERY AND DISPLAY

    $result = mysql_query("SELECT * FROM bob2");

    echo $result;

// if this is commented out I get the 'connected' message above. without it the page is blank,  
    while ($row = mysql_fetch_assoc($result)) {
    echo $row["Danumber"];
   
}
    
*/


    echo "<br> <br> <br>";

Answer 1

There are a lot of possibilities here. You could try, for example, the following things:

• Use mysql_num_rows to check how many rows have been returned
• Use print_r to print the whole row.
• Use isset to check that the key "Danumber" actually exists

Summarizing: use a lot more checks to make sure things you retrieve are actually there.