Newbie confusion about the database docs

[eluser]xwero[/eluser]
The example says: select all the title columns from the table mytable where the id is $id start from row 10 and limit the result to 20 rows. It's almost plain English.

The get method executes the query and returns a object that makes it possible to get the results if the query is returned without errors. By assigning the object to a variable you can use the object to get the result of the query in the way you want.

w3schools sql section is basic but gets you up to speed. after reading the tutorials you probably will notice that the AR select method isn't equal to the SELECT sql statement, as the insert and update methods are, but it's a quirk that is easy to understand.