The first UPDATE updates all records with tdtime='0000-00-00 00:00:00'. For the rest 49 updates there's nothing to do. You have to use WHERE clause that uniquely identifies each record you want update in each loop itteration.
>Thanx,
> i have one more doubt.. I'm trying to update a Mysql database from this array..
>
>FOR i=1 TO gncount
>lctime=ttime[i]
>SQLEXEC(lccon,"UPDATE mytab SET tdtime=?lctime WHERE tdtime='0000-00-00 00:00:00'")
>next
>
>I know this code is buggy because the tdtime field in the Mysql database is being set to one value only.. How can i update the field "tdtime" with successive values from the array??
>
>The first 50 records in Mysql are set to 0000.. and i want to update them from the array(50 values in this array)
>
>and thanx for that array fix..
--sb--