update into timestamp

[jpbal]

hello,
what is wrong?
$result=mysql_query("UPDATE tempo_best_mto SET t_best='$temp_orange$numeroLigne]', hu_best='$hu_orange[$numeroLigne]' WHERE id_depot='$id_depot'
AND num_site_mto='$num_site'
AND date_validite ='$date_validite[$numeroLigne]'");

The update is in fact INSERT with the current date-time
$date_validite[$numeroLigne]='20030212080000' for example
date_validite is a TIMESTAMP(14)
INDEX id_depot,num_site_mto,date_validite

How can i do that efficiently
thanks

[Joan Garnet]

Try this one:

Code: Select all

$result=mysql_query("UPDATE tempo_best_mto SET t_best = ".$temp_orange[$numeroLigne].", hu_best = ".$hu_orange[$numeroLigne]." WHERE id_depot == ".$id_depot." AND num_site_mto == ".$num_site." AND date_validite == ".$date_validite[$numeroLigne]);

Is one of the possible ways..

bye!

[jpbal]

hi,
sorry but no difference, they are INSERTION and not UPDATE with a date_validite=current date/time of my PC

[Joan Garnet]

I think I didn't understand you...
Can you repeat the question please...
;)
ThanX