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