When using PHP3 with an Informix Dynamic Server 2000 installation, it's impossible to get any kind of "sensible" results.

E.g. when I try to connect to the database, then do a select statement, ifx_num_rows returns 0 no matter how many rows are in the table. Ofcourse, ifx_fetch_row doesn't fetch anything either.

The strange thing, however, is that when I use ifx_htmltbl_result, it gives me a correct table with all the information I wanted. In this case, a simple select * . After using ifx_htmltbl_result, I call ifx_num_rows, and this time it returns the number of rows PLUS ONE, so if two rows are in the table, ifx_num_rows returns 3 (three)! And on top of it all, if I try ifx_affected_rows, it tells me 10, no matter how the table looks like.

But still, ifx_fetch_row does not work.

It seems to be something fundamentally wrong here - please have a look at it!