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