Re: [PHP-WIN] inserting into MS SQL database- query failed

2001-08-29 Thread Andrian Pervazov
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

[PHP-WIN] inserting into MS SQL database- query failed

2001-08-29 Thread Joann Coffey
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 wa