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 - [EMAIL PROTECTED]
Phone: 626.968.6424 x210 | Fax: 626.968.6877
Wireless #: 714.315.8954 | Wireless E-mail:
----- Original Message -----
From: "Martin Clifford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
