Hello.
> How to force to kill process which make lock of table ? since PHP make
> many persistent connection to MySQL and i don't know
> which one is locking the table :(
You may get information about processes on your MySQL server using SHOW
PROCESSLIST
and kill the weird process with th
I have an PHP that do application
$sql = "SET AUTOCOMMIT=0";
$db->execQuery($sql);
$sql = "DELETE FROM TABLE X WHERE...";
if($db->execQuery($sql)){
print "ERROR ";
exit(0);
}
$sql = "INSERT INTO TABLE ";
if($db->execQuery($sql)){
print "ERROR ";
exit(0);
}
I have a persistent conne
Hello,
I tried to execute the following form:
and the following script PHP:
Operazioni su joke
// If the user wants to add a joke
if (isset($_POST['addjoke'])==true):
?>
Type your joke here:
else:
// Connect to the database server
$dbcnx = @mysql_pco
