PHP and FreeTDS problem

Tasos Angelis tangelis at tasos.gr
Mon Oct 11 07:54:08 EDT 1999


>Can you post a small script demonstrating the problem so I can try to
>replicate it here?


Yes of course.
The script follows. I use the persisten connection in it.
I also used it with standard connection.
I forget to say that I use the 0.47beta version of FreeTDS.
The Artists table has got 2 columns. An integer and a varchar(50).

The script follows:

<html>
<body>
<center>
<table>
<tr><td colspan=2>PlayList from Tempo</td></tr>
<?  
 ignore_user_abort(1);
 $res=mssql_pconnect("tasosa","tempo","tempo");
 if(!$res):
?> 
 <tr><td colspan=2>Could not connect to Tempo</td></tr>
  
<? 
 ELSE:
 $what=mssql_select_db("Tempo",$res);
 $what=mssql_query("select * from Artists",$res);
 
 list($id,$name)=mssql_fetch_array($what);
 
 while($id):
  echo "<tr><td>$id</td><td>$name</td></tr>";

  list($id,$name)=mssql_fetch_row($what);
 endwhile;
    endif; 
?>
</table>
</body>
</html>






More information about the FreeTDS mailing list