[SOLVED] UPDATE FOR .field?

[l3asturd]

ok, I'm trying to UPDATE a row based on the username.

 

So, I assume to code looks something like:

 

<?php
$update_result = mysql_query(UPDATE $dbtable SET $dbtable.Score = "Updated Score" FOR ($dbtable.Name =($POST_['Username']));


?>

 

Now I realize this is probably completely way off, but this is how I have interpreted that it should be done.

So, I type in a username, and in theory, it should UPDATE the usernames score to "Updated Score" right? Someone please explain how this is SUPPOSED to be done?

[chronister]

Almost, the proper syntax for an update query is

 

$query="UPDATE tablename SET fieldname='$newvalue' WHERE fieldname='$fieldnamevar'";
$result=mysql_query($query);

 

 

This is the general syntax. You should use an ID in the where clause so you get the correct record updated with minimal chances of error.

 

Nate

[l3asturd]

genius, thanks!