Re: INSERT problem with MySQL/PHP

Todd, Did you echo $sql and examine it? Did you try the statement at the mysql console? Does the list of values exactly match the field list? Did you try the alternate syntax .... INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name SET col_name=expression, col_name=expression, ... as in the MySQL docs? I'm really curious about what $sql looks like when you echo it. I've been surprised more than once. Miles Thompson At 04:11 PM 6/18/01 -0700, Todd A. Jacobs wrote:

PHP: 4.0.4pl1 MySQL: 3.23.36-1 I have the following code fragment, which uses the same connection parameters elsewhere to *successfully* to retrieve data from a database, so this doesn't appear to be a permissions problem with MySQL. However, nothing happens with inserts; no rows are added at all. All I get is a message form mysql_error() saying "Query was empty." Can anyone tell me what might be wrong?

    $user_idx  = 1;
    $objective = 1;
    $question  = 'Foo';
    $question_type = 'singular';

    $connection_id = mysql_connect ('192.168.1.1', 'php', 'password')
        or die ("No connection.\n");

    $sql = "INSERT INTO question VALUES (NULL, $user_idx, $objective,
        '$question', '$question_type', NULL, NULL)";

    $result = mysql_db_query('item_db', $sql_query, $connection_id);

    echo "<pre>";
    echo "\nDebugging output:\n";
    echo "\tSQL: $sql\n";
    echo "\tError: ", mysql_error(), "\n";
    echo "\tLast insert ID: ", mysql_insert_id(), "\n";
    echo "\tResult: $result\n";
    echo "</pre>\n";

-- Todd A. Jacobs CodeGnome Consulting, LTD