MySQL is being gay.

[NSA]

So,

I have an update query like so:

"UPDATE chat_admins SET username = '" . $username2 . "',password = '" . $password . "',key = '" . $key . "' WHERE username = 'admin' AND password = 'password'";

But whenever I try and run the stupid thing, I get this retarded error:

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 'key = '6070' WHERE username = "admin" AND password = 'password'' at line 1

I tried removing the " ' " from the query, still nothing.
Sometimes, when I run this query it messes up my database too.
When I try to go into "chat_admins" it takes me back to phpMyAdmin's home page which means I have to re-create it (using an import).

Any help with this?

 

[Weasel]

I honestly can't find any mistake in the query. Maybe your table is fucked up? For the last thing I recommend to contact your hosting if phpMyAdmin fucks up.

 

[ViiTactiiCZz]

try
"UPDATE chat_admins SET username = '" . $username2 . "' AND password = '" . $password . "' AND key = '" . $key . "' WHERE username = 'admin' AND password = 'password'";

 

[NSA]

That won't work.

 

[TesoMayn]

mysql_query("UPDATE chat_admins SET username = '{$username2}', password = '{$password}', key = '{$key}' WHERE username = 'admin' AND password = 'password'");

 

[NSA]

mysql_query("UPDATE chat_admins SET username = '{$username2}', password = '{$password}', key = '{$key}' WHERE username = 'admin' AND password = 'password'");

Still getting the same error :/

 

[TesoMayn]

mysql_query("UPDATE chat_admins SET username = '{$username2}', password = '{$password}', key = '{$key}' WHERE username = 'admin'");

 

[NSA]

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 'key = '6598' WHERE username = 'admin'' at line 1

The query worked before I implemented the key.

 

[TesoMayn]

What exactly is the key for?

 

[NSA]

Password recovery purposes.

 

[Weasel]

What is the value of the key field? How is it designed?

 

[NSA]

I had it as varchar(655), turned it to int and even tried text

 

[Weasel]

I assume its still an int, is it int(4)?

 

[NSA]

It is indeed

 

[Ecko]

mysql_query("UPDATE `chat_admins` SET `username` = '" . $username2 . "', `password` = '" . $password . "', `key` = '" . $key . "' WHERE `username` = 'admin' AND `password` = 'password'");

 

[NSA]

mysql_query("UPDATE `chat_admins` SET `username` = '" . $username2 . "', `password` = '" . $password . "', `key` = '" . $key . "' WHERE `username` = 'admin' AND `password` = 'password'");

You must be registered for see links

saves the day once again.