Hi
I have a strange problem on my website which uses PHP4 together with mySQL. On several pages the users can edit information in regular forms. The strange thing is that sometimes (like quite often) the data they enter do not seem to get into the database! This does only occur when UPDATE-statements are used, and it have never happened during an INSERT.
This problem has become especially visible when I have started to use sessions in a wider extent than before.
I wonder if it is some kind of time issue so the query is not really executed, since I often use something like:
// check if database should be updated
if($fname!="" || $flname!=""){
$query = "UPDATE yada yada";
mysql_query($query, $db);
Header("Location: index.php");
}
else {
//show the formpage etc
}
Should one have to set somekind of delay between the execution of the query and the Header()-command?!?!
I am really furious... ;-)
I have a strange problem on my website which uses PHP4 together with mySQL. On several pages the users can edit information in regular forms. The strange thing is that sometimes (like quite often) the data they enter do not seem to get into the database! This does only occur when UPDATE-statements are used, and it have never happened during an INSERT.
This problem has become especially visible when I have started to use sessions in a wider extent than before.
I wonder if it is some kind of time issue so the query is not really executed, since I often use something like:
// check if database should be updated
if($fname!="" || $flname!=""){
$query = "UPDATE yada yada";
mysql_query($query, $db);
Header("Location: index.php");
}
else {
//show the formpage etc
}
Should one have to set somekind of delay between the execution of the query and the Header()-command?!?!
I am really furious... ;-)