PHP and FreeTDS problem
Brian Bruns
camber at umcc.ais.org
Mon Oct 11 08:04:33 EDT 1999
Forgive me if I'm just not seeing it, but there is no mssql_close() to
close the connection when done.
Cheers,
Brian
On Mon, 11 Oct 1999, Tasos Angelis wrote:
> >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