How do I get the results of an SQL query?

Question

Using Delphi 2010, I have used TSQLQuery and TSQLConnection to connect to a remote MySQL server. I have used an SQL query as follows:

SQLQuery1.SQL.Text := 'SELECT * FROM registered WHERE email="'+email+'" and login_pass="'+password+'"';

SQLQuery1.Open; // Open sql connection

What should I do to list or display the data selected by this query?

When I type

SQLQuery1['who']; // The resault is : James Kan

I think it is displaying the very last item in the list. But I want to display each item, as I could with the foreach loop in PHP. How could I create, for example, a TLabel for each item?

Answer 1

You just iterate over the resultset like

SQLQuery1.Open;
SQLQuery1.First; // move to the first record
while(not SQLQuery1.EOF)do begin
   // do something with the current record
   ...
   // move to the next record
   SQLQuery1.Next;
end;

Answer 2

You can use a TDBGrid to display the results quite neatly. You need a datasource which links to your query via the DataSet property of the datasource. Then the DBGrid links to the dataSource via the DataSource Property of the DBGrid.