Re: INSERT problem with MySQL/PHP
| From: | Todd A. Jacobs | Date: | Tue, 19 Jun 2001 01:23:29 +0000 |
| Subject: | Re: INSERT problem with MySQL/PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-54310@lists.php.net to get a copy of this message | ||
On Mon, 18 Jun 2001, Todd A. Jacobs wrote:
> $sql = "INSERT INTO question VALUES (NULL, $user_idx, $objective,
> '$question', '$question_type', NULL, NULL)";
>
> $result = mysql_db_query('item_db', $sql_query, $connection_id);
Thanks to all who answered. It was a simple mistake, but hard for the eye
to catch: I needed the query to use $sql, not $sql_query.
The program now works properly. Thank you.
--
Todd A. Jacobs
CodeGnome Consulting, LTD