Re: mssql insert

[Miles Thompson <milesthompson@xxxxxxxxxxxxxxx>]

>$query = "INSERT INTO myTable VALUES ('".$myVar."');';
Check the commas?
Miles

At 05:50 PM 3/28/2004 +1200, Martin Ryan wrote:
> Got a dumb-ass question for you all.  I have got insert queries working with
> mssql_query($query); except if any of the variables have two or more words.
> For example:
> $myVar = "Two or more words";
> $query = "INSERT INTO myTable VALUES ('".$myVar."');';
> mssql_query($query,$db);
>
> The query will only insert "Two".
>
> I know the query is correct, because I've echoed it, cut it, and pasted it
> directly into Query Analyzer and it comes up roses.
>
> Cheers muchly,
> Marty
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php