Hi all, Im newbie here and newbie in Delphi. I want to use MySQL there. I use file mysql.pas which provides almost same functions as in PHP Have problem allready -


Q := 'SELECT name, mail FROM users';

mysql_query(db, PChar(Q));

res := mysql_use_result(db);

showmessage(inttostr(mysql_num_rows(res)));

for i:=0 to mysql_num_rows(res) do begin
row := mysql_fetch_row(res);
Form1.usersGrid.Cells[0, i+1] := row[0];
Form1.usersGrid.Cells[1, i+1] := row[1];
end;

mysql_free_result(res);


WHY ON EARTH there is only one row returned????
Thanx