Help. I've got a script I know works. It update a record in a table fine. However it just seems to decide to stop working. It doesn't produce an error (mysql errno : 0) so I'm at a loss.
If I delete the data fields that I'm trying to update. It'll then update the fields, and all following attempts to update work.
However I left it overnight I just went back to it and it now doesn't work. I delete the contents of the fields again and voila, it works.
Anybody know why?
update statement below.
Nick Gushlow.
----------oOo-----------
$insert_result = mysql_query("UPDATE calls
SET short_log = '$new_short_log',full_log = '$new_full_log'
WHERE dws_call_id = '$call_id'
");
If I delete the data fields that I'm trying to update. It'll then update the fields, and all following attempts to update work.
However I left it overnight I just went back to it and it now doesn't work. I delete the contents of the fields again and voila, it works.
Anybody know why?
update statement below.
Nick Gushlow.
----------oOo-----------
$insert_result = mysql_query("UPDATE calls
SET short_log = '$new_short_log',full_log = '$new_full_log'
WHERE dws_call_id = '$call_id'
");