FreeTDS Development Group

["Geoff Winkless" <geoff.winkless AT farmline.com>]

"Albert Mok" <doneeta AT hotmail.com> wrote:
> I would like to have some information regarding the 'insert' statement
> into MS SQL. I have tried for some times but I still can't make it while I
> can do the 'select' statement already. By the way, I'm using PHP 4.03 in a
> Linux box and MS SQL 7.0 under Win2k. I wrote the code as follows:
>
> $result = mssql_query("insert into $xxx values ('xxx', 'xxx')");

Interesting. Does it work if you specify the column names in the query
statement?

Geoff