[eluser]Unknown[/eluser]
I'm building a TV guide for my site which uses the framework; the views work great, haven't quite figured out how to use MySQL with it yet though.
I'm planning to paginate sort of like this:
http: library.digiguide.tv/lib/programmenextshowing/12578
This is part of the code in my view file:
That's all manually entered in for now; but how could I get it to be rendered from the database and convert times from displaying as 10:00:00, 16:30:00 etc. to 10:00am, 4:30pm
etc. and paginate the MySQL results so they render like in library.digiguide.tv/lib/programmenextshowing/12578 with their style of pagination?
Note that my site is inspired by,
but not a copy of theirs.
I've got the basics of CodeIgniter working well, but need it to create a login system etc. so I can update this TV guide platform without having to manually update the data via PhpMyAdmin every time etc. Note that I'm .htaccess - protecting the login to just localhost, so deny from all should be used [I think].
This newbie needs some help; had a look on Google but not quite sure how to implement this!
Cheers
*can't post links though, so you'll have to manually cut-and-paste them.