Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming Query problems
Query problems
  • El Forum
    Unregistered
  •  
#1
02-17-2009, 12:33 PM

[eluser]Laranjeiro[/eluser]
Hi
I'm new at CI and I got a problem. I have been searching in the forum for a long time and I could not find the resolution for my problem.
I'm designing a web page for a motorcycle club. In one page is intended to keep a journal of their activities. I created a table called journal that contains, among other fields, title, id and body.
In the first page I want to show the last inserted item and a list of the last 20 titles.
My doubt is how to show the last item and how to keep the list of the last titles.
I could make a query that would retrieve all the information and them only show the info I need but I am a performance freak and I want to do things the right way.
Any suggestions?


Messages In This Thread
Query problems - by El Forum - 02-17-2009, 12:33 PM
Query problems - by El Forum - 02-17-2009, 01:13 PM
Query problems - by El Forum - 02-17-2009, 01:14 PM
Query problems - by El Forum - 02-17-2009, 01:42 PM
Query problems - by El Forum - 02-17-2009, 01:50 PM
Query problems - by El Forum - 02-17-2009, 06:14 PM
Query problems - by El Forum - 02-17-2009, 06:29 PM
Query problems - by El Forum - 02-17-2009, 06:42 PM



Theme © iAndrew 2016 - Forum software by © MyBB