RE: [PHP] INSERT problem with MySQL/PHP

[Jason Murray]

> 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);
                                          ^^^^^^^^^^

I daresay this will be the problem since the SQL is in $sql.

Jason