[freetds] PHP 4 + Freetds 0.60 + SQL Server 2000

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Mon Sep 13 11:05:56 EDT 2004


> 
> Hello,
> 
> Since 2 years ago we use freetds 0.52 to connected between PHP and SQL
> Server.
> 
> Due to problem with the euro character (€) we upgrade to Freetds 0.60.
> 
> But now we've got a big problem with the php function mssql_query or
> mssql_fetch_array.
> 
> When my query return an empty result the link identifier 
> return 1 instead of
> a true link identifier (# XX)
> 
> 
> Do I need to upgrade again or any other idea.
> 
> Thanks and excuse for my poor english
> 
> Cedric
> 
> 
> **************
> * in my code *
> **************
> echo 'first query';
> $sql = "select COLONNE_1 from MY_TABLE where 1=1";
> $rs = mssql_query($sql) or die($sql);
> echo $rs. '<br>';
> $row = mssql_fetch_array($rs);
> echo row["COLONNE_1"] . '<br>'. '<br>';
> 
> echo 'second query';
> $sql = "select * from MY_TABLE where 1=0";
> $rs = mssql_query($sql) or die($sql);
> echo $rs. '<br>';
> $row = mssql_fetch_array($rs);
> echo row["COLONNE_1"] . '<br>'. '<br>';
> 
> **************
> * it's write *
> **************
> first query
> Resource id #5
> TOTO
> 
> second query
> 1
> Warning: mssql_fetch_array(): supplied argument is not a 
> valid Sybase result
> resource in ......
> 

??
2 years ago we released 0.60, I don't understand why you choose 0.52 version... This year we release 0.62 (current it's 0.62.4 with some additional fixes in CVS) and we are going to release 0.63 (famous last words :) )... yes, I think it's time to try a new version :)...

freddy77



More information about the FreeTDS mailing list