Generate Table From Query ( Where? )

[eluser]Future Webs[/eluser]
you do the database work in the model
assign the query in the controller and pass to the view
display the table using the echo statement in your view