only pull one row from db to display problem

[eluser]Craig A Rodway[/eluser]
In that case, you should read the page about URLs in the user guide.

The first segment represents the controller class that should be invoked.
The second segment represents the class function, or method, that should be called.
The third, and any additional segments, represent the ID and any variables that will be passed to the controller.

From your example, mysite.com/events will call the index function of the event controller - which will work OK. But when you try to go to mysite.com/events/868, it will not work because the 868 function doesn't exist in the events class.

You have two options - make the URL include index mysite.com/events/index/868; or add a manual route like this using Routing.

Code:

$route['events/(:num)'] = 'events/index/$1';