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

$rs = DB::Query("select * from carsmake");
 
while( $data = $rs->fetchAssoc() )
{
echo $data["id"];
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