* Santino ([EMAIL PROTECTED]) wrote: > I use : > > numRows = mysql_num_rows( Result); > numFields = mysql_num_fields( Result); > > for( j=0; j < numRows; j++) { > mysql_data_seek( Result, j); > CurrentRow = mysql_fetch_row( Result); > for( k = 0; k < numFields; k++) > printf( "%s\t", CurrentRow[ k]); > printf( "\n"); > } > > and it works > Try to add > > mysql_data_seek( Result, 0);
I'll remember the mysql_data_seek call. However, I did find my problem. It seems I was calling mysql_fetch_row( Result) once BEFORE returning to my calling routing to fetch the rows out, thus I was only getting the last 6 rows. DOH! Thanks for the help. -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `' GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux -- The power of freedom "Claiming that your operating system is the best in the world because more people use it is like saying McDonalds makes the best food in the world." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]