Has anyone ran into problems where mysql_num_rows() return 0 when the result set clearly contains a certain number of rows? My C code looks something like this:
mysql_query(conn, "show databases"); result = mysql_store_result (conn); numRows = mysql_num_rows (result); On an HP 11.11 machine running MySql 3.23.39, mysql_num_rows() always returns 0. After mysql_store_result() gets called, MYSQL_RES.num_rows is set to 0. It works fine on a sparc and alpha. I can do mysql_fetch_row() just fine, and mysql_num_fields() works, but mysql_num_rows() would still return 0. Anyone seen this same problem before? Thanks, Hebron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]