Skip to Content.
Sympa Menu

freetds - Re: PHP and FreeTDS problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: PHP and FreeTDS problem

Chronological Thread  
    < Chronological >       < Thread >
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP and FreeTDS problem
  • Date: Mon, 11 Oct 1999 08:04:33 -0400 (EDT)


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>
>



Archive powered by MHonArc 2.6.24.

Top of Page