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

Reply via email to