PHP+FreeBSD+FreeTDS - connection lost.

Micaele Ereshenco mic at ic.ru
Thu Dec 30 08:25:15 EST 1999


Hello everybody!

I can't do update my table from php-script. After sending query with 
"update ....; commit" or anything distinct from "select", i lost connect to 
SyBase server. Example my script:

==================================
$res=sybase_query("select id,CheckOk from mic.web_Links where CheckOk=1") 
or die("Error select 1!<br>\n");
$row=sybase_fetch_row($res);
echo "ID=$row[0], CheckOk=$row[1]<br>\n";
sybase_free_result($res);
//sybase_query("update mic.web_Links set CheckOk=0 where id=$row[0]");     
//sybase_query("commit");                                                  
/*
This is may be anything query. Working only "select". :(
*/
     
$res=sybase_query("select id,CheckOk from mic.web_Links where CheckOk=1") 
or die("Error select 2!<br>\n");
sybase_fetch_row($res);
echo "ID=$row[0], CheckOk=$row[1]<br>\n";
==================================

This script stably returned to me "Error select 2!", if i do "update...". 
Update however is executed, i see it from next time, when run this script 
again, but i want updating in loop!

FreeBSD 3.2; FreeTDS 0.50; PHP 3.0.12.

Best regards,
Mic.



More information about the FreeTDS mailing list