Try using single quotes for the columns in your query:
$SQL = "
INSERT INTO $table_name
(f_name, l_name, username, password)
VALUES
('$f_name', '$l_name', '$username', '$password')
";
SQL SERVER doesn't accept double quotes - I wonder how you were able to
run the query in Query Analyzer witrh double quotes
Andrian
Joann Coffey wrote:
>
> 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
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
