MYSQL UDF Problem

[Cybernetic]

Hello everyone.

I have a MYSQL UDF problem as seen in title. The problem is as follows:

I run a query which should generate 14 rows of data, however when i try to retrieve it through a function it only recieves the first one. Here is the code of said function.

func get_creature_stats($my_db_user, $my_db_pass, $my_db_name, $my_ip, $get_creature_stats)
Local $my_error=_MySQLConnect($my_db_user, $my_db_pass, $my_db_name, $my_ip, "{MySQL ODBC 3.51 Driver}","3306")
$z=0
            $creature_stats_obj=_query($my_error,$get_creature_stats)
            ;with $creature_stats_obj
            ;   while not .EOF
            for $field in $creature_stats_obj.Fields
                    if $z=0 Then
                        $creature_stats=$creature_stats_obj.Fields("creature_stat_name").value&"|"&$creature_stats_obj.Fields("stat_value").value
                    Else
                        $creature_stats=$creature_stats&"|"&$creature_stats_obj.Fields("creature_stat_name").value&"|"&$creature_stats_obj.Fields("stat_value").value
                    EndIf
                    $z=$z+1
                    ;.MoveNext
            ;   WEnd
            ;endWith
             MsgBox(0, "", $z)
            Next
_MySQLEnd($my_error) ; we close db
MsgBox(0, "", $creature_stats)
return $creature_stats
EndFunc

Can anybody help me with this please?

Thank you

Edited January 6, 2013 by Cybernetic

[Cybernetic]

Nevermind, figured it out.

[jchd]

Yeah you commented the while not .eof and .movenext.

Note that you can fetch all data at once in a 2D array by using the .getrows() method.