Database API:Query()

Executes an SQL Query that returns data, i.e., SELECT * FROM TableName.

Syntax

DB.Query(SQL)

Arguments

SQL

an SQL query.

Return value

A QueryResult object.

Example

dynamic data;
dynamic rs = DB.Query("select * from carsmake");
while(data = rs.fetchAssoc())
{
  MVCFunctions.Echo(data["id"]);
  MVCFunctions.Echo(data["make"]);
}

See also:

•QueryResult object: fetchAssoc()

•Database API: Exec()

•Database API: Select()

•QueryResult object: fetchNumeric()

•QueryResult object: value()

•Using SQL variables

•About Database API