This won't add to my database

[Anon]

For some reason this value won't add to my database, there are others that will add, but this one does not. Any ideas.

$NewsMsg = "<a href='javascript:void(0);' onMouseOver='overlib(\"Application Service Providers are third-party firms that manage and deliver software-based services to customers across a wide area network. ASPs allow companies to out-source some or all aspects of their technology requirements.\", CAPTION,\"Definition: asp \")' onMouseOut='nd()'> asp </a>";

$query="insert into $article_file (ArtMsg) values ('$NewsMsg')";

[Anon]

try assigning $NewsMsg with single quotes.
This is whats used by most sql databases so its a good idea to stick with it.

ie.
$NewsMsg='<a href="javascript: void(0);"
onMouseOver="overlib(\'Applia ... ';

the try your insert command as is

hope this helps,stef

[Anon]

I've done that, as well as tried exactly what you have done in your example and if I were to echo the variable, it works perfectly, but it still won't add it to the database.

[thepriest]

try escaping any single quotes (ie ' -> \' )

echo the query variable, check that quote nesting is correct.