I'm using autocomplete to select some fields from my Mysql DB. Everything works fine, the autocomplete is working ok.
The only thing is when I submit the form to the database I always have to refresh my page before I see the result fromt the update query. The update is performed ok as it is changing the values in the database. When I remove the autoupdate jquery script from my page it is working fine the value update without page refresh.
Here's the code of my jquery script:
$(document).ready(function(){
$("#tag").autocomplete( {
source: 'autocomplete.php',
minLength: 3,
select: function(event, ui) {
event.preventDefault();
$("#tag").val(ui.item.label);
$('#PARTNER_ID').val(ui.item.value);
}
});
});
I do the update query, and in Php I have this code after the sql update:
if($result2){
header("location:contact_detail.php?ID=".$CONTACTS_ID);
}
What is the problem?