Re: MySQL Query Acting Up

I would suggest using ' instead of " for SQL queries... That's what I use... so much easier. $query = "UPDATE articles2 SET title='$title', brief='$brief', doclink='$doclink' WHERE article_id='$id'"; Then I would print the query: print( "$query\n" ); Then if it still looks right, try manually typing it in a CLI interface. -w -- William Fong - wfong@mookandblanchard.com Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 714.315.8954 | Wireless E-mail: ----- Original Message ----- From: "Martin Clifford" <MLC1@nrc.gov> To: <php-db@lists.php.net> Sent: Thursday, June 20, 2002 10:03 AM Subject: [PHP-DB] MySQL Query Acting Up 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