PHP/SQL Help

[benjy355]

I hope somebody here knows php well >_> Because this thing is pissing me right off
Anyways, for some reason my sql UPDATE query doesn't work right. It says it does everything fine, but I check the database, and nothing changes!

$query = 'UPDATE `cp_logindata` SET `sessionkey` = \'' . $sessionkey . '\' AND CONVERT(`sessionkey` USING utf8) AND SET `failedlogins` = \'0\' AND CONVERT(`failedlogins` USING utf8) AND SET `lastip` = \'' . $_SERVER["REMOTE_ADDR"] . '\' AND CONVERT(`lastip` USING utf8) LIMIT 1;';

mysql_query($query);

-Tyvm

 

[Andrew275]

You need to separate with commas instead of AND statements. Ex:

UPDATE `mytable` SET `field1`='3', `field2`='hello', `field3`='world'

 

[benjy355]

>_> Then phpMyAdmin lied to me...
Thanks
*Tries*
What about converting though?
(CONVERT('something' using utf8))

 

[sittal]

benjy making more spam sites again?

 

[benjy355]

No... My website.

 

[sittal]

awww... thosr spam sites gave me quite a laugh, and made me laugh more when i sent them ot evil_genius

 

[benjy355]

>_> Then phpMyAdmin lied to me...
Thanks
*Tries*
What about converting though?
(CONVERT('something' using utf8))

Nevermind! I don't have to convert my charsets

And thanks! It worked