array/database/template

[exportforce]

For example I have a table with UserID, Points, Timestamp,open and I want to fetch it

PHP Code:

$ergebnis=$db->query_read('SELECT * FROM ' . TABLE_PREFIX . 'lotto WHERE open="1" ORDER BY gameid DESC'); 


(Open is just for me to know if this row is still being used. If it is 1 it will be needed)

So if I fetch it via mysql_fetch_object how do I use that so I can create a list ? Normally I would just use a while and echo, but here I have to register the variables to the template...
So how would I use this?

thanks