In my code i use odb_exec with informix to get the result from a select count(*) from .... but always return 1, if I copy the same select into the dbaccess of the informix the result is 0, I'm losing my mind tring to figure it out why is not working if someone can help i would apreciate it. Here is my code :
$querc1 = "select count(*) from info_archivo where nombre_archivo like '%MSG02314.WAV%' and cod_usu_ar = 2";
$totc1= odbc_exec($conn_id,$querc1) or die("<p>ERROR : ".odbc_errormsg());
odbc_fetch_into($totc1,&$respuest) ;
echo "RES".$respuest[0]."<br>";
and always print 1 but that information is not in the database
