<?php require_once "ClassLoader.php"; echo "<h1>Testing SQLSelectQuery</h1>"; $sqlSelectQuery = SQLSelectQuery::parseSQL("SELECT id, login, passwd AS Secret FROM Member WHERE status='Active' AND id>'2' ORDER BY login ASC LIMIT 5"); echo $sqlSelectQuery->toString(); echo "<br/><br/>"; $sql = new SQLSelectQuery(); $sql->select("id"); $sql->select("member.name as name"); $sql->select("count(*) as num"); $sql->from("access"); $sql->leftjoin("member", "access.member_id", "member.id"); $sql->where("access.type='GET'"); $sql->having("num > 1"); $sql->groupBy("member.name"); $sql->orderBy("num DESC"); $sql->limit("25"); echo $sql->toString();