Upgrade mySQL to 4.1.10a Insert record problem

[hanuman]

I recently upgraded from

PHP Version 4.1.2
mySQL version: 3.23.58

to

PHP Version 4.3.6
mySQL version: 4.1.10a-standard

and fully functional scripts are behaving strange. One of the issues is that the php script stop adding new records.

$dbcategory=mysql_db_query("database_name","insert into table_name (field1, field2) values('$field1','field2')");

there is no fatal error of any kind but the script does not append new records.....

any idea how to start debugging the issue

[ikke]

Hello,

I have the same version of mysql and this piece of code works for me, maybe it is usefull for you.

$query = "INSERT INTO orders VALUES ('$id', '$v', '$k[0] $m $k[1]', '$k[2]', '$k[3]','$k[4]', '$e', '$klant', '$datum', '$bezorgen')"
$result = mysql_query($query);
if(!$result) error_message(sql_error());//ERROR

[coopster]

More than likely it is this issue:

[webmasterworld.com...]

[hanuman]

thanks.