Problem with mysql_num_rows() on HP and MySql 3.23.x

2004-12-02 Thread Hebron Mak
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 machin

mysql_num_rows() on Solaris

2003-03-13 Thread Hebron Mak
I am attempting to use mysql_num_rows() after mysql_store_result(), but the return value is always 0. The documentation says that it will not work if I use it after mysql_use_result() without doing a fetch first, but I am doing a mysql_store_result() instead, which should work right away. This se