I've made a prepared statement like "select col1 from tab where col2 = ?"
there are no problem in binding parameters and executing the statement.

However when I fetch the results, I found that there is nothing fetched (I'm sure that rows that fit the condition exist) and the server returns MYSQL_NO_DATA.

I have other prepared statements using INSERT and it's ok. It that mysql do not support prepared statements using SELECT with binding parameters?

thank you very much
Arthur Lam