Jump to content

[SOLVED] Mysql error (UPDATE)


Hamlets666

Recommended Posts

$feedme="UPDATE users SET read='$newread' WHERE name='$name'";
mysql_query($feedme) or die(mysql_error());

[b]Error:[/b]
[i]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read='1' WHERE name='Dyzaster'' at line 1[/i]

[b]Table:[/b]
[i]CREATE TABLE `users` (
`id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` TEXT NOT NULL ,
`pass` TEXT NOT NULL ,
`mail` TEXT NOT NULL ,
`about` TEXT NOT NULL ,
`read` BIGINT NOT NULL
) ENGINE = MYISAM ;[/i]

What`s wrong?
Link to comment
https://forums.phpfreaks.com/topic/31708-solved-mysql-error-update/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.