[SOLVED] Syntax question AND WHERE?

[YourNameHere]

I need to select a row and update it.

 

I need to select a column against 2 columns, cname and owner.

 

$skillsInsert = "UPDATE `dd`.`chars` SET `skillPoints` = '4' WHERE `chars`.`Owner` = `Cody` AND WHERE `chars`.`cname` = `Silk` LIMIT 1 ;";
$result = mysql_query($skillsInsert);

 

I got $skillsInsert from phpMyAdmin and added the AND WHERE clause to it.

 

This is what I get when I echo the error

 

Could not connect: 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 'WHERE cname = `Silk` LIMIT 1' at line 1

[Mchl]

WHERE condition1 AND condition2

 

No need to repeat WHERE

[YourNameHere]

Ok, makes sense.

 

I updated it and now I get another error.

 

Could not connect: Unknown column 'Cody' in 'where clause'

 

UPDATE `dd`.`chars` SET `skillPoints` = '4' WHERE `chars`.`Owner` = `Cody` AND `chars`.`cname` = `Silk` LIMIT 1 ;

[YourNameHere]

Ok I figured it out.

 

First of all I removed the semi-colon at the end of the query as that is not allowed.

 

then I changed the `` to '' and it worked.

since `` is not treated as as single-quotes.