this works on win2000, not on linux.
i have a table called "Works" with about 30 fields. Two fields have a fulltext index- one called "Title" (varchar(64)) and "Description" (longtext).
If I have two records, both with the value "Test 1234" in the Title field and delete one using the following code:
$query = "delete from Works where id='".$did."'";
connectDB();
$result = mysql_query($query);
closeDB();
the table is corrupted.
Works | check | error | Found 825 keys of 826 |
| 67046_3.Works | check | error | Corrupt
If i send the var $did to a function to delete the record:
function deletework($wid){
$query = "delete from Works where id='".$wid."'";
print "q: $query<br>";
connectDB();
$result = mysql_query($query);
closeDB();
}
i can delete the first of the above mentioned 2 records, but deleting the second corrupts the table.
under windows 2000, i can delete both records without corruption.
-n
