Updating a record problems

[Anon]

Hi there,
I have a problem updating a record. I'd like to give my clients an option where they can update their records, but when I use the replace into statement it does not get executed! Let me show an example. You have the following fields:

IDnumber (unique identifier)
name
description
address
email address
title

the statement reads:
REPLACE INTO tbl_name SET IDnumber=$idnumber,name=$name,
address=$address;

I've let out 3 fields (could this be the problem?) and also I want to now if you could add a WHERE clause. I can't see how MySQL will know which record to update.

Thanx
Stiaan

[Anon]

Read the mysq manual:

REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a unique index, the old record is deleted before
the new record is inserted.

[Anon]

Hi Stiaan,
I hope the database your are trying to use is MySql.If that is the case then try this syntax:
UPDATE tablename SET Fieldname1='Value',Fieldname2='value' WHERE
condition.
Leaving out fields will not be a problem I think.Just try the previous Syntax and please mail me the result.

[Anon]

Don't leave out the WHERE in and UPDATE statement, or it will update ALL rows!