Re: MySQL Query Acting Up

From:	user at domain dot invalid	Date:	Thu, 20 Jun 2002 17:15:04 +0000
Subject:	Re: MySQL Query Acting Up
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-19915@lists.php.net to get a copy of this message

in your SET title=\"$title\", statement you forgot the second backslash before the double quote. I would start there. Martin Clifford wrote:

Howdy all, If someone call tell me why this MySQL query is not working, I'd be VERY thankful. I don't see a damn thing wrong with it, but I could have been looking at it too long. Here is the query: $query = "UPDATE articles2 SET title=\"$title", brief=\"$brief\", doclink=\"$doclink\" WHERE article_id=\"$id\""; $result = mysql_query($query, $connect)
     or die(mysql_error());
No errors are produced, yet the query doesn't do anything. Nothing in the row changes. Any help would be appreciated! Martin