The SET clause has to come before WHERE clause - Russ
---
Toolshed Computer Productions - Professional PHP Hosting
Hosting - Dedicated Servers - Design - Programming
http://www.toolshed51.com
-----Original Message-----
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 2:04 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql error, dont see why.. please help
Shouldn't it be:
mysql_query("UPDATE user_polls SET url = '$file_name' WHERE uid =
'$UserName' AND type = '$type") or die (mysql_error());
Maybe I'm wrong.
--
Tyler Longren
[EMAIL PROTECTED]
Currently Unemployed
www.noworkfortyler.com
On Tue, 22 May 2001 17:00:35 EDT
[EMAIL PROTECTED] wrote:
> Here is the command.
>
> mysql_query("UPDATE user_polls WHERE uid = '$UserName' AND type = '$type'
SET
> url = '$file_name'") or die(mysql_error());
>
> Output
> You have an error in your SQL syntax near 'WHERE uid = 'Oblivion' AND type
=
> 'music' SET url = 'test'' at line 1
>
> This is SOOO weird.
> PLEASE HELP
>
> - Peter
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]