[PHP-DB] Re: MySQL Query Acting Up
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySQL Query Acting Up
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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MySQL Query Acting Up
Thanks everyone! Between all the replies I was able to locate the problem and fix it! It wasn't the missing backslash (that was a typo, which sucks). I wasn't properly passing the article_id field to the query, so MySQL had a problem with WHERE id=. Thanks again! :o) Martin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php