Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived General Discussion need sql help
need sql help
  • El Forum
    Guest
  •  
#5
10-13-2009, 06:20 PM

[eluser]theprodigy[/eluser]
Doing it in multiple queries, I don't mind. I want to try to stay away from having to use PHP to check for bills whose payments are equal to or greater than the bill because I plan on keeping this for a while. The more bills I add, the longer it will take because there are that many more bills to have to compare to. At the beginning, it wouldn't be that bad, but after a while (and not exactly a long while), you're looking at pulling hundreds of bills from the database that will never get shown because they are already paid.

If I can get the query to only pull the bills that still have a positive amount due, then that's less processing I have to worry about.


Messages In This Thread
need sql help - by El Forum - 10-10-2009, 04:42 PM
need sql help - by El Forum - 10-13-2009, 06:15 AM
need sql help - by El Forum - 10-13-2009, 12:07 PM
need sql help - by El Forum - 10-13-2009, 06:01 PM
need sql help - by El Forum - 10-13-2009, 06:20 PM
need sql help - by El Forum - 10-13-2009, 06:57 PM
need sql help - by El Forum - 10-13-2009, 07:08 PM
need sql help - by El Forum - 10-13-2009, 07:22 PM
need sql help - by El Forum - 10-13-2009, 07:33 PM
need sql help - by El Forum - 10-14-2009, 09:07 AM
need sql help - by El Forum - 10-14-2009, 09:45 PM
need sql help - by El Forum - 10-15-2009, 04:45 AM
need sql help - by El Forum - 10-15-2009, 08:03 AM
need sql help - by El Forum - 10-15-2009, 10:53 AM
need sql help - by El Forum - 10-15-2009, 09:16 PM



Theme © iAndrew 2016 - Forum software by © MyBB