* 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]

Reply via email to