How can setup this mysql databse for my 1st project in CI?

[eluser]phantom-a[/eluser]
I don't get how to use it. The pagination works. I tried someone's demo,
here created the model for the page.
But does not work in the manner I wish it. It will just dump the entire table on the page with its field arrays and stuff.
I can't get it too take my SQL qeury

Code:

'SELECT `url`,`id`,`date`,`hits` FROM `links` WHERE `category`=1 ORDER BY datestamp'

either then I just get php errors or an empty page.