[SOLVED] Update Column only in an sql statement

[johntp]

Hey guys,

 

I'm not sure how to set this up. I want to update only one column in a row in php.

 

when i try

 

<? $query  = "REPLACE INTO visitors (TimeOut) VALUES ( '$TimeOut') WHERE EmployeeID = '$Employee'; ?>

 

but it needs a value for all of my columns in that row to update.

[wildteen88]

If you only want to update a single column within a row you use the UPDATE query, eg

$query  = "UPDATE visitors SET TimeOut='$TimeOut' WHERE EmployeeID = '$Employee'";

[discomatt]

REPLACE INTO works well, but you have to read the syntax. There shouldn't be a WHERE clause - it takes a primary or unique column and if a duplicate exists, it updates rather than inserts.

 

<? $query  = "REPLACE INTO visitors (EmployeeID, TimeOut) VALUES ('$Employee', '$TimeOut')"; ?>