inserting into MS SQL database- query failed
| From: | Joann Coffey | Date: | Wed, 29 Aug 2001 15:30:34 +0000 |
| Subject: | inserting into MS SQL database- query failed | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-9117@lists.php.net to get a copy of this message | ||
I am trying to insert some data from an html form to a php script (using MS
SQL, PWS on Win 98, PHP 4.0.5 cgi) - but I keep getting the following
error:
Warning: MS SQL: Query failed in C:\Inetpub\wwwroot\php\do_adduser.php on
line 24
When I executed the query using Query analyzer the record was added to the
dbase but when trying to submit the info through the form it is not
successful - I would appreciate any help as I am not sure how to find out
what the problem is.
Here is the insert statement from do_adduser.php
$SQL = "
INSERT INTO $table_name
(f_name, l_name, username, password)
VALUES
(\"$f_name\", \"$l_name\", \"$username\", \"$password\")
";
Thank you.
Joann