[Resolved] Replace?

ejwf

I want to overwrite information in a certain record with new info.
I am trying

$sql = "REPLACE INTO tblUser (CName, CPhone, CFax, CLogIn, CPass, CEmail)
WHERE tblUser.CName = '$CurrentUser'
VALUES ('$CName', '$CPhone', '$CFax', '$CLogIn', '$CPass', '$CEmail')";
$result = mysql_query($sql)
or die(mysql_error());

but I get the error message;
You have an error in your SQL syntax near 'WHERE tblUser.CName = 'g' VALUES (' go', 'go', 'go', 'go', 'go', 'gog')' at line 2

looking at mysql manual it doesn't make any reference to the use of WHERE in the query, but how can I replace information in a specific row without a WHERE clause?

TIA

Gosdrykkur

Shouldn't the WHERE clause come after the VALUES(...) clause!

Just a thought!

ejwf

have tried this - but still got error message
You have an error in your SQL syntax near 'WHERE tblUser.CName = 'g'' at line 3

it doesn't seem to like WHERE at all........

Gosdrykkur

What about ...

$sql = "update tblUser set CName = '$CName', CPhone = '$CPhone', CFax = '$CFax', CLogIn = '$CLogin', CPass = '$CPass', CEmail = '$CEmail' where CName = '$CurrentUser'";

$result = mysql_query($sql) or die(mysql_error());

ejwf

yes !
that's done it - many thanks