Update syntax no good

[Methonis]

Can't figure out what I'm doing wrong. I want to go into my members table, and for each member if their avatar column is Bruce_Willis.jpg, have it update the column so avatar is set to blank.gif. This is what I used in my php script:

$result1 = mysql_query("UPDATE '{$db_prefix}members' SET avatar='blank.gif' WHERE avatar='Bruce_Willis.jpg'");

I have an error report on, which it does come up and this is the error: Error updating the DB. SQL 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 ''yabbse_members' SET avatar = 'blank.gif' WHERE avatar = 'Bruce

Any clues?

Thanks,

Methonis

[ahundiak]

Don't put quote marks around table names.
Use:
UPDATE yabbse_members SET ...
Instead of:
UPDATE 'yabbse_members' SET ...

Note: sometimes you will see what appears to be quote marks around table and column names. These are actually back ticks ` and are used to avoid reserved words. They are not normally needed.

[Methonis]

Holy cow, that was simple. Thank you very much. I'd thought I need the ' ' around the table because it used a variable {$db_prefix} and was under the impression that variables need the ' ' around them, or is that only for if you use variables in columns and such?

[laserlight]

for table names and (most) other identifiers, you can optionally enclose them in backticks, `

it is the values that should be enclosed in quotes.