Skip to Content.
Sympa Menu

freetds - PHP+FreeBSD+FreeTDS - connection lost.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Micaele Ereshenco" <mic AT ic.ru>
  • To: freetds
  • Subject: PHP+FreeBSD+FreeTDS - connection lost.
  • Date: Thu, 30 Dec 1999 8:25:15


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.



  • PHP+FreeBSD+FreeTDS - connection lost., Micaele Ereshenco, 12/30/1999

Archive powered by MHonArc 2.6.24.

Top of Page