Mysql InnoDB PHP result problem

i have a strange problem :
MySQL 4.0.21 innodb and php 4.3.9-1
all tables are in innodb type.

For a simple select statement sometimes i get result and sometimes
nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random
behaviour.
If my table is MyISAM type no problem.

If someone have an idea ?

Hi!

Could this:
<a rel="nofollow" style='text-decoration: none;' href="http://dev.mysql.com/doc/mysql/en/innodb-consistent-read-example.html" target="_blank">http://dev.mysql.com/doc/mysql/en/innodb-consistent-read-example.html</a>
explain it?

Regards,

Heikki

"josys64" kirjoitti
viestissä:3682befd.0502090704.3f02b647@posting.google.com...
 >i have a strange problem :
 > MySQL 4.0.21 innodb and php 4.3.9-1
 > all tables are in innodb type.
 >
 > For a simple select statement sometimes i get result and sometimes
 > nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random
 > behaviour.
 > If my table is MyISAM type no problem.
 >
 > If someone have an idea ?